Conditional Formatting for Highlighting Dates | Excel forum

Hi Lisa

Thanks for your reply. All possible, with differing degrees of difficulty!

For your first question, you can have theoretically unlimited rules on a single cell / selection. Your latest rule is coming last and overriding the others. To edit this, select the affected cells, go to Home > Conditional Formatting > Manage rules. Your rules will be listed here. Click the up / down arrows to move the rules up and down in order of execution, and pay attention to the Stop if true option, will will halt any further conditional formatting rules being applies.

For the second question, you can do it but you'll have to be a bit more precise in your rules. The method I listed earlier will _not_ work for this. Select all the cells to be affected by the rule and go back to New rule and select Use a formula to determine which cells to format.

Assuming your first date is in cell A1, try the following formula:

=$A1<TODAY()+30

Then choose your formatting as before. The dollar signs in that reference are *very* important. Do change your column / row to the first occurrence of the date in your table.

Give it a go and let me know how you get on.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector