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

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

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,723
Messages
5,626,505
Members
416,187
Latest member
L_D18

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