Conditional Formating Excel 2003

TheBanker

New Member
Joined
Mar 30, 2012
Messages
14
Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
<o:p></o:p>
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-com:eek:ffice:smarttags" /><st1:State w:st="on"><st1:place w:st="on">AL</st1:place></st1:State> has a format applied that:<o:p></o:p>
<o:p></o:p>
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:p></o:p>
Any help appreciated:confused:

The banker:eek:
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Fotis1991

New Member
Joined
Mar 30, 2012
Messages
13
Hi

Try this, in conditional formatting rules

Code:
=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

Well-known Member
Joined
Nov 7, 2006
Messages
8,350
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

New Member
Joined
Mar 30, 2012
Messages
14
Hi

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

Watch MrExcel Video

Forum statistics

Threads
1,127,215
Messages
5,623,433
Members
415,974
Latest member
ZorroOP

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top