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
<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