Link to home
Start Free TrialLog in
Avatar of Farah Mohammed
Farah MohammedFlag for United States of America

asked on

Excel Conditional Formatting Help

I have a spreadsheet (see attached) for which I need to add some conditional formatting.
I would like the row to be filled in when column E (ETA_DATE) is older than today.

So, in the spreadsheet, rows 3, 7 and 10 will need to be highlighted.

Thank you for your help.
Book2.xlsx
SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Column E needs to be changed to date

So use Data>Text to column>date

Then conditional format based upon formula

=E2<=Today()

Colour Yellow Fill applied

See attached.
Book2.xlsx
Avatar of Farah Mohammed

ASKER

I am resending my spreadsheet again. The above worked on my sample but not on the actual spreadsheet. I had dates after today highlighted, etc.

The sample I have entered manually some older dates but on this attachement is actually how the date is after running SQL.
Book2.xlsx
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The_Barman - that worked excellent. Thank you both for your help.