Using the Today function

Hi Charlotte

Thanks for getting in touch. Yes this is possible by using the OR function. The OR function looks like this:

=OR(criteria1, criteria2)

When either of the criteria are met, it returns TRUE and switches the conditional formatting on. Your formula will look like this:

=OR(A1=TODAY(),A1=TODAY()+1)

You enter this by selecting your range, going to Conditional Formatting on the Home tab, select New Rule > Use a formula to determine which cells to format. Enter the formula then use the format button to select your formatting style.

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