1. Select the Range (say A1:A10) or column A. Please note that the cell
reference A1 mentioned in the formula is the active cell in the selection.
Active cell will have a white background even after selection

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=AND(B1<TODAY(),C1="",A1<"",B10)

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK



If this post helps click Yes
---------------
Jacob Skaria


"lemur99" wrote:

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