If you select all rows that you want to include and start with the first row
number ($C2) it will be applied to all rows you have selected


--
Regards,

Peo Sjoblom



"oceanmist" wrote in message
...
Will I be able to replicate the formula reference (=$C2="Completed) down
various lines?

"David Biddulph" wrote:

Use "Formula is", rather than "Cell value is", within conditional
formatting. If your active cell when you apply the formatting is in row
2,
use "Formula is" =$C2="Completed" noting the absolute addressing for the
column and relative addressing for the row.
--
David Biddulph

"oceanmist" wrote in message
...
I need to do some conditional formatting on certain lines in a
spreadsheet.
Can you please advise how to do this:

Here is what it needs to do -

If Cell in this line in column C reads "in progress", make the entire
line
yellow;
If Cell in this line in column C reads "overdue", make the entire line
red;
If Cell in this line in column C reads "Completed", make the entire
line
green

Many thanks.