Search results

Here, sorry

I need the 'FALSE' un filled. And the rest colour coded. Heres a screenshot for extra help

I just cant get it working Condition 1: is equal to =AND(TRUE, $D$4 =-1) Condition 2: is equal to =AND(TRUE, $D$4 =0) Condition 3: is equal to =AND(TRUE, $D$4 =1) If the cell is 'TRUE' and D4 is '-1' be Green If the cell is 'TRUE' and D4 is '0' be Orange If the cell is 'TRUE' and D4 is '1'...

Hi guys, I have another query. Ive got my spreadsheet/timeline working how i want it to, but now I have added a 'Probability' column. I now need the month-fills colour coded: Red if -1 Orange if 0 Green if 1 I cant get mine working, It colours the correct cells but also fills the...

Heres what i need. I got the colours working, but it applied the formatting to all the 'False' values and not just the 'True' values i need.

Thanks for your help. I need one more thing: Another column called 'Probabalitiy'. There will only be 3 options for Probability (-1, 0, 1) I need 3 colours based on the probability. so if start 01/01/2010 and finish 01/04/2010 and probability 1 then I need a specific colour for the...

You are my hero! Exactly what I need! thank you so much

I dont think excel recognises dates... I used =$K$4 >= 01/01/2010 and it fills the cell i wanted, but if I put in a date 01/01/2009 (for example) it still fills. It is quite obvious 01/01/2010 is > 01/01/2009 but excel cannot work it out. Also if I leave the '>' out - =$K$4 = 01/01/2010 the...

Is this possible with conditional formatting? Ive tried = AND($K$4>=1/12/2009, $L$4 <= 30/12/2009) which (should) colour the corrosponding cell under month December as red. But it doesnt work. I also tried ranges = AND($K$4>= 01/01/2009, $L$4 <= 30/03/2009) to fill 3 month blocks (Jan...

Hi, I have a spreadsheet with numerous columns and I wish to make a 'timeline' (filling cells with a colour based on 2 dates). Example: Project ID - Date Start - Date finish AA0011____01/01/2010_01/03/2010 AA0012____01/02/2010_01/04/2010 then i'd have my timeline to the right of it...

k, i treid again with this code... still nothing happens at all... Private Sub cmdButton_Click() Dim sql As String, tdf As DAO.TableDef, fld As DAO.Field, db As DAO.Database 'set database & tabledefs (I use "tblSource" as your table name) Set db = CurrentDb Set tdf = db.TableDefs("Table2")...

Hi thanks for the code but it doesn't seem to work. I changed all the Tablesource names to Table2 (my table name) and changed other bits for the first part and the closing part of the SQL select query, but when i hit the button nothing happens... no error or anything... Heres the code...

Can you help me now? Selecting all excluding Nulls. Please I have tried everything

Well... thanks. Waste of time posting anything on here.

Anyone have any ideas?

Thanks for your reply. Could I ask for an example? I'm not too hot with VBA in access. Am i correct in saying i need to create a module?

Can someone please help! I need this urgently. Any help is highly appreciated

Your method removes 'Records' if >0. I want Feilds removing if there are no values for any record.

All this check sum does is add all the values on the end of the query... None of the feilds you have in the table have no values, there is at least one value in each feild. In query2 for example: if F5 did not have the value '3' for rec_no '3' I would want that excluded (f5) from the...

Cant believe how simple this could be... Yet I cant find any help anywhere... there must be 1000's of DB's out there with similar needs and there must be a solution.