CODEWITHSUNDEEP
excelexcel-formulaexcel-2010formula
Dane Cameron
Dane Cameron

Reputation: 433

Excel - Conditional Formatting to highlight if cell value equals and another cell value is before date

I'm trying to make a conditional formatting formula to highlight the row if EmployeeStatus in Column I equals "Terminated" and if EmployeeStatusDate in column J is before 2/1/2019. Here is what I have so far, but it doesn't seem to work. What am I doing wrong?

=IF(AND(I3="Terminated", J3<""), "2/1/2019", "")

enter image description here

Upvotes: 0

Views: 146

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

use this:

=AND($I1="Terminated", $J1<>"", $J1<DATE(2019,2,1))

the cell reference must be the top row of the Applies to: Range

Upvotes: 1

Related Questions