I'm trying to conditionally format an entire table so that the rows highlight
rew when a date is passed. However, when I copy the format the reference for
both column and row remain absolute rather than changing as the row moves up
or down. I'm using the formula:
=IF(TODAY()=($A436+14)*AND(ISBLANK($F436)),0,1)
So that if something is two weeks after the inital date and the cell where a
completed should have been entered is blank, then FALSE is returned and the
cell will highlight red.