Farah Mohammed
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The_Barman - that worked excellent. Thank you both for your help.
So use Data>Text to column>date
Then conditional format based upon formula
=E2<=Today()
Colour Yellow Fill applied
See attached.
Book2.xlsx