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
Farah MohammedBuyerAsked:
Who is Participating?
 
SteveConnect With a Mentor Commented:
Use this formula in an end column:

=DATEVALUE([@[ETA_DATE]])

Then format off that column.
Book2.xlsx
0
 
NBVCConnect With a Mentor Commented:
Select the whole range, starting at A1 to F10,

Go to Home|Conditional Formatting|New Rule

Select to "use a formula to determine which cells to format"

enter formula:

=AND($E1<>"",$E1+0<=TODAY())

then click Format and choose from Fill tab.
0
 
SteveCommented:
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
0
 
Farah MohammedBuyerAuthor Commented:
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
0
 
Farah MohammedBuyerAuthor Commented:
The_Barman - that worked excellent. Thank you both for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.