Conditional formatting applied incorrectly on dates

[Concaveman]

I have attached a simplified version of the file I am working on. Essentially, I want to flag (highlight in yellow) dates (formatted as YYMMDD) which have elapsed, with additional conditions:
-Cells without a date are not highlighted
-Column A value is FALSE (unchecked)
-Column H does not equal "Yes"
-Column I does not equal "Lost"

You will notice in the attached file that rows 2-3 are highlighted incorrectly. I have tweaked the formula many times but I cannot pinpoint the error.

Note: in order to correctly retain the desired date formatting for the cells, dates must be entered in the cell in the format "dec 15, 2025".

 

[AliGW]

Try this:

=AND(G2<>"",G2<=References!$E$2,B2="No",H2<>"Yes",I2<>"Lost",A2=FALSE)

 

[AliGW]

Or, if you mean not to consider column B:

=AND(G2<>"",G2<=References!$E$2,H2<>"Yes",I2<>"Lost",A2=FALSE)

 

[AliGW]

I am wondering, though, whether it is column C and not column A that you really want to consider?

 

[Concaveman]

Hi Ali, thanks very much for the replies. I tried these but the same cells still appear highlighted. Column C distinguishes a lead from an opportunity and I have applied a separate formatting rule on columns H and I for this. If the project is complete (Column A = TRUE), I do not want column G highlighted.