Forum Discussion
Conditional Formatting with multiple date conditions
See if this does what you want.
Select the rows that you want to format.
In the following, I will assume that the active cell in the selection is in row 11. If it is in another row, adjust the formulas accordingly.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula =AND($I11="",$H11>$K$7)
Click Format...
Activate the Fill tab.
Select blue.
Click OK, then click OK again.
Repeat the above steps, but with the formula =AND($I11="",$H11<$K$7) and blue as fill color.
Could you attach a sample workbook without sensitive data? Thanks in advance.
Sorry been out. There you go. Been trying something similar but don't get the expected results.
See if this does what you want.