Line =- row? If so select ranges needed (click in the row headers and select
as many as you need), do format conditional formatting, select formula is

=$C1="In Progress"
click the format button,. select pattern and yellow, then click add and add
another condition, repeat but use "Overdue" and red patterns and repeat for
"Completed"

Then click OK



--
Regards,

Peo Sjoblom


"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.