Notifications

Hi Jessica,

Thank you for the forum question.

I can see that you have done our Excel Intermediate course. I would use Conditional formatting to highlight when someone has passed or is reaching their probation period.

Select all the dates in the sheet. Click Conditional Formatting and click New Rule. Select the second option Format only cells that contain. Select Cell value Greater than or Equal to and by typing =Today() as criteria Excel will highlight all dates you need. Click Format and decide how you want it highlighted. And click OK.



Kind regards

Jens Bonde
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