Conditional Formatting by expired date

[sdjames1979]

Hi there

Column H (H1 column title = Turnaround) is full of deadline dates, I would like all dates from yesterday and previous to turn red (text only).

Please help.

Thanks

Sarah

[ELeGault]

Set the following in CF Rules - the only thing you need to type will be

Today()

Conditional Formatting |
New Rule |
Format only Cells that contain|
Cell Value |
Less than |

Today()

Click format and under Font choose the red you wish it to turn. You are done, Hit ok, Ok.

Cheers

ELeGault

[azumi]

You can custom format with formula :

For Yesterday :
=TODAY()-1

For Previous Day :
=TODAY()+1