Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

conditional formatting date

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting for date >= -30 days from todays date

Conditional formatting for date >= -30 days from todays date

ResolvedVersion 2013

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

Edited on Thu 24 Oct 2013, 17:57

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

Attached files...

GF Conditional Date Formatting.xlsx
GF-cond-form-date.png

Thu 31 Oct 2013: Automatically marked as resolved.

Excel tip:

Generating simple column charts

1.Select cell range containing data/figures
2. Press F11

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.