Conditional formatting cells by date

[Lewis]

I am trying to set a sheet in which some cells have dates entered. I want the background colour to change when todays date is 30 days or less than the date in the cell and another colour when todays date is after the date in the cell. I am assuming htis could be done by conditional formatting.

Is it possible to make the cell flash if todays date is after the date in the cell?

 

[maxflia10]

Try
=today()-a1<=30 and
=today()>a1

The "flashing" part needs VBA
This message was edited by maxflia10 on 2002-10-16 23:42

 

[rmtaylor]

SELECT FORMAT, CONDITIONAL FORMATTING
Select CELL TO RECEIVE CONDITION
Click on Format, and use a "Formula Is" condition.
Example
If cell A5 has today() (formula to specify show today's date )
and say cell B5 is where the +30 day condition will apply
the formula is conditionwould be =$B5>$A5+30

NB both rows must be formated to the Date Format

To Copy the formatting down select the row where the condition is applies say
click on copy .
Select area where the formatting is to be copied to,
Click on EDIT, PASTE SPECIAL then select FORMATTING.

The conditional formatting will be active in this array of cells

A TYPICAL EXAMPLE HOW TO NEST FORMULA USING AN OR, AND STATEMENT TO ACHIEVE MORE CONDITIONS
Highlight cells to be affected by conditions the enter as below

=OR($B3="PASS",$B3="ABORT")
=AND($B3<3,$E3="FAIL)"
=$E3="FAIL"
AND SO ON