Siobhan has attended:
Excel Intermediate course
Excel Advanced course
Project Management - Framework & Processes course
PowerPoint Intermediate Advanced course
Conditional formatting for date >= -30 days from todays date
Hi There,
I am wanting to highlight cells that contain a date that is >=-30 days from todays date i.e. commence highlighting 30 days prior to the date reaching todays date.
I have tried entering a formula into the greater than conditional formatting but am not having success.
Any help appreciated.
I look forward to your response.
Thank you,
Siobhan
RE: Conditional formatting for date >= -30 days from todays date
Hi Siobhan
Thanks for getting in touch. This is a common tricky issue; you're not the first person to have come unstuck.
The formula you need is "less than =TODAY()-30". I've attached a workbook with an image to help explain this. The formatting is on cells C2:C11.
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
GF Conditional Date Formatting.xlsx
GF-cond-form-date.png
