Can you conditionally format a whole row based on data in one cel

[Gordy72]

Hi

I have a spreadsheet listing work items one one column and the due data due
another column. Once the work is completed the complettion date is entered
in a third column.

What i need is to condtionally format the data so that if the work is
completed before the due date all the data in the whole row goes one colour
and if the completion date exceeds the due date the data in the whole row
goes a different colour.

The conditional formating rules only seem to allow me to change colour of
the data in one cell, i.e.

Is there a way to conditonally format the whole row based on the data in one
cell?

Thanks

 

[Sheeloo]

Yes.

Suppose you want to higlight the range A1:Z1 if A1 contains YES
then select the range (If you want whole row then select whole row... You
can also apply this to A1 and then paint over the range...)
in Conditional Formatting use FORMULA IS as
=$A1="YES"

You can also refer to two cells like this
=$E1>$Y1
or
=(Today()-$E1)>30


Note the $ before A1... this does the trick since when this condition is
trasnlated to B1, C1... it still refers to A1
Also this helps you paint this down rows since 1 changes to 2,3... (No $
before 1)
You can refer to any cell, even outside the range. You just need to take
care that it translates to the write formula when Excel applies it to other
cells.