Hi,
I am trying to apply the following conditional formatting rule:
=AND($I$1<TODAY(),ISBLANK($L$1))
This should test if a value in column "I" is less than today's date AND if column "L" is not blank. If so, it should highlight the cell.
However it highlights some cells where column "L" is not blank (on the corresponding row).
Do I need to enter fixed cell references, as above? I cannot see how to enter a formula that will apply to all cells in column "I". I also do not understand why the formula doesn't work for all cells.
Any help greatly welcomed!
Thanks
Bookmarks