Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
49
Views
Topic starter
Hey Folks -
Hoping for help here - see below.I am trying to write a formula in which 2 variables trigger a conditional formatting of the cell.
For cell H9, if H9 is a date before TODAY, and I9 is a value other than "Completed", format that cell to be a different color.
I tried the conditional formula =IF(AND($H$9<TODAY), $I$9<>"Completed")
Things that maybe influence:
*H column is itself populated by a formula
*I column is a dropdown list
Posted : 17/01/2024 1:44 pm
Hello,
You can skip the IF function, go with =AND(H9<TODAY(),I9<>”Completed”)
Br,
Anders
Posted : 17/01/2024 7:24 pm