Can I format a row based on the contents of one cell?
 

For example: I have a table of data that contains the column 'status'. If
the contents of the 'status' cell is COMPLETE, I want to change the color
format of the row (i.e. make it grey).

Can I format a row based on the contents of one cell?
 

Yes, use conditional formatting, select the whole row and use a formula of

=$A1="COMPLETE"

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Kirsty" wrote in message
...
For example: I have a table of data that contains the column 'status'. If
the contents of the 'status' cell is COMPLETE, I want to change the color
format of the row (i.e. make it grey).