L
lemur99
Hi,
I've got a spreadsheet set up as:
Column A - task
Column B - Expected completion date
Column C - Actual completion date
and I want to set it up so that all tasks that have not yet been completed
but should have been are highlighted in red (that is, for example, if B2<
todays date and C2 is blank then A2 is highlighted red).
I've been messing about but can't seem to get it right in the conditional
formatting - any suggestions?
thanks
I've got a spreadsheet set up as:
Column A - task
Column B - Expected completion date
Column C - Actual completion date
and I want to set it up so that all tasks that have not yet been completed
but should have been are highlighted in red (that is, for example, if B2<
todays date and C2 is blank then A2 is highlighted red).
I've been messing about but can't seem to get it right in the conditional
formatting - any suggestions?
thanks