Conditional Formating Excel 2003

[TheBanker]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have a spreadsheet with columns A475 - AX475 and would like to set a conditional format such if column AK has a date in it, then column <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-comffice:smarttags" /><st1:State w:st="on"><st1lace w:st="on">AL</st1lace></st1:State> has a format applied that:<o></o>
<o></o>
If the date in AK is greater than a date range of “now()-7 to now()-10” it goes one colour and then “now()-11 to now()- 150” it goes another. Clearly I need to ignore the fact that a cell in AK may be blank.<o></o>
Any help appreciated
The banker

 

[Fotis1991]

Hi

Try this, in conditional formatting rules

=AND($AK1<(TODAY()-7);$AK1>(TODAY()-11))

Same way for the second one.

Also, if you have to do it, change the semi-colons, to gomma.

 

[Special-K99]

Try

=(AND(AK1>=NOW()-7,AK1<=NOW()-10))
and format as required

and

=(AND(AK1>=NOW()-11, AK1<=NOW()-150))
and format as required

If AK1 lies within any of those ranges then it cannot be blank

 

[TheBanker]

Hi

Thank you for your speedy responses. I used Special-K99's and the fisrt part work, however the second equations didnt. any ideas?