Excel conditional formatting help!!!

[2014olympicgold]

i Had to upload this as an attachment because the question and detail was "too long" for Dobber

[horrorfan]

I think I figured this out for you.

Make sure you have clicked on the first cell that should be applied (C2 i.e. 16 nov 15)
The rule type needs to be 'use a formula to determine which cells to format'.
Add this formula (or equivalent): =$C2<>"" (meaning starting at C2, highlight the cell which doesn't contain a blank.
Choose the fill colour and click ok.
In the 'applies to' field box, highlight the entire cell of data (excluding the headings), and click 'apply'.

I'm not sure if there's another way to ensure it only identifies a date, in case accidently other text appears in those cells?

That's one way that should work. Let me know.

[ericdaoust]

I found this while doing a google search and tried it with a valid date and an invalid one.

=IF(NOT(ISERROR(DATEVALUE(TEXT(A1,"mm/dd/yyyy")))),"valid date","invalid date")

I'm not really able to go all the way with the testing to make it work in conditional formatting but you should be able to do something with this.

[2014olympicgold]

Holy sweet jesus you're a mastermind genius wrapped in a oracle.

This is exactly what i wanted. To Horror

TO Eric, i'll try to incorporate that one too to have it specific to a date, not just a cell being filled in.

Thanks you two. really helped me look smart for the boss.

[ericdaoust]

Not sure if you got everything working but I had a few minutes and successfully applied a date checker in conditional formatting.

The formula should be: =NOT(ISERROR(DATEVALUE(TEXT($C2,"mm/dd/yyyy"))))

and apply it to the row as horrorfan stated. Basically in my example putting "01/10/2001" in C2 causes the affected cells to be colored red, but if I change C2 to something like "aaa" then the formatting goes away.

[horrorfan]

Holy sweet jesus you're a mastermind genius wrapped in a oracle.

This is exactly what i wanted. To Horror

TO Eric, i'll try to incorporate that one too to have it specific to a date, not just a cell being filled in.

Thanks you two. really helped me look smart for the boss.

Glad it worked out. And nice find, Eric, on the date-specific formula.