Formatting question

P

Philip Drury

I have a spreadsheet where we are capturing customer contact. The first
column contains the date that the call came in, I want to format the table to
make the row green if the date in column 1 is within 5 days from todays date,
to turn amber if it goes over 5 days and red if it goes over 7 days. The
last column will contain the date that the query was completed, when a date
is input into this field I want the row to 'grey' out. Can anyone help????
 
B

Bob Phillips

See http://xldynamic.com/source/xld.CF.html#lights

Your formulae would be

=AND($A2<=TODAY(),$A2>TODAY()-5)

=AND($A2<=TODAY(),$A2>TODAY()-7)

=AND($A2<=TODAY(),$A2<>"")

where A2 is the first cell being formatted

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Philip Drury said:
I have a spreadsheet where we are capturing customer contact. The first
column contains the date that the call came in, I want to format the table to
make the row green if the date in column 1 is within 5 days from todays date,
to turn amber if it goes over 5 days and red if it goes over 7 days. The
last column will contain the date that the query was completed, when a date
is input into this field I want the row to 'grey' out. Can anyone
Click to expand...
help????
 
P

Philip Drury

Have tried this but it's not working, probably me I know! However, this will
just change the date cell the required colour - I really want to turn the row
the relevant colour? Any ideas?
 
Top