IF statement in conditional formatting

[MurphDog]

Trying to apply some conditional formatting to M6:M20. What am I doing wrong here? The cell values are dates

This sample formula works in cells
=IF($M6>(VLOOKUP($G6,Table1,5,0)),"Pass","Fail")

Thought I could use this to turn the font red if the date in M6 (format mmm-yy) is greater than the corresponding date in Table1 Column 5 (date format mm/dd/yyyy)

=$M6>(VLOOKUP($G6,Table1,5,0))

 

[jasonb75]

if m6 > vlookup , then turn red

For that part, try
=$M6>(TEXT(VLOOKUP($G6,Sheet1!$B$4:$F$19,5,0),"0;;;")+0)

For the remaining 'do not format' values, no rule is required.

 

[MurphDog]

Thanks Jason, your previous suggestion didn't work, but the last one did, perfectly. Thank you!!

For what it's worth, prior to seeing your last suggestion, I did get it working with the following formula, but I like yours much better.

=NOT(OR(VLOOKUP($G6,Sheet1!$B$4:$F$19,5,0)>M6,VLOOKUP($G6,Sheet1!$B$4:$F$19,5,0)=""))