Forum Discussion
Solved
Conditional Formatting with multiple date conditions
Hi All, If anybody can help me with the formulas for conditional formatting or anything else that would work. I am trying to format as: if there is a date closed ($I), the row to remain white. ...
See if this does what you want.
Hi malihassan
Follow these steps:
1- Selcect all the rows ( in your case seems 4 row),
2- From the home tab --> on the style group -->Conditional formatting --> New rule
3- choose Use a formula to determine which cells to format --> write this formula =AND($I10="",$H10>$K$6)
4- Click format button --> choose the color blue
5- Click OK --> OK
Repeat the same step for the second condition and write this formula: =AND($I10="",$H10<$K$6)
Please find ready worksheet attached