Conditional formatting list of dates within last 90 days

[damianberry]

In cells C300:C305 I have the last 6 dates I have used sick leave at work, most recent being in cell C305.

If we here at work use more than 3 days in a 90 day period, we are subject to discipline.

I would like to be able to put the entire range in conditional formatting to use a red font to show any dates that are within 90 days of today().

Any help would be appreciated.

Thanks,
Damian

[:) Sixthsense :)]

Try this...

1. Select range C300:C305
2. Choose Format|Conditional Formatting
3. From the first dropdown, choose Formula Is
4. For the formula, enter
=(TODAY()-$C300)<=90
5. Click the Format button.
6. Select a font colour to match the cell colour.
7. Click OK, click OK

Please be aware that the above formula refers C300 cell as active cell so C300 should be the active cell in your selection

[damianberry]

Thank you very much! Excellent!