Conditional Formatting - Given dates within certain range of days

[Tee51]

Hi,

Is there a way to highlight cells that have dates that are within 12 t
15 days and 30 to 35 days?

Example:
A1 = 2/7
A2 = 2/1
A3 = 1/19
A4 = 2/15

I would like cell a2 and a3 to be highlighted (preferably differen
colors).

Thanks in advance

 

[Kevin@Radstock]

Hi Tee51

For the conditional formatting rules.
Assuming your data is column A:

Rule 1 Between 12-15 days from today:
=AND($A1<>"",$A1>=TODAY()+12,$A1<=TODAY()+15)

Rule 2 Between 30-35 days from today:
=AND($A1<>"",$A1>=TODAY()+30,$A1<=TODAY()+35)

Kevin

 

[Tee51]

Sorry Kevin,

But this is not what I was trying to do. I would like column A t
highlight instead of having additional columns show true or false. Also
the text is only coming back with false.

Thanks for your help. I'll take my time and figure something out

 

[Kevin@Radstock]

Those additional columns are for example!!

I gave you the answer.
Conditional formatting for Excel 2007 >
Select column A or a range of cells in column A that you wish to appl
the rules. Home Tab > Conditional Formatting > New Rule > Use a formul
to determine which cells to format > Formula for Rule 1 goes into th
box > Format as required > OK > OK. Do the same for Rule 2.

Rule 1 Between 12-15 days from today:
=AND($A1<>"",$A1>=TODAY()+12,$A1<=TODAY()+15)

Rule 2 Between 30-35 days from today:
=AND($A1<>"",$A1>=TODAY()+30,$A1<=TODAY()+35)

Sorry Kevin,

But this is not what I was trying to do. I would like column A t
highlight instead of having additional columns show true or false. Also
the text is only coming back with false.

Thanks for your help. I'll take my time and figure something out

+-------------------------------------------------------------------
|Filename: 005-Conditional Formatting - Given dates within certain range of days.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=763
+-------------------------------------------------------------------

 

[Tee51]

Figured it out

This is what I was looking for. Thanks for your assistance

=AND($A1<>"",$A1<=TODAY()-30,$A1>=TODAY()-35
=AND($A1<>"",$A1<=TODAY()-12,$A1>=TODAY()-15

+-------------------------------------------------------------------
+-------------------------------------------------------------------