colour of a row depending on cell value

M

Maax

Hi all, is it possible to change the colour of the font in a row depending on
one of the cell values in that row?
I can obviously use conditional formatting to change the font in the
particular cell that holds the data i will use, but i would like the entire
row to be formatted.

Basically i want the row to change to a light grey font when a particular
cell within that row says complete.

Is this at all possible?

any help appreciated.

Regards
 
J

JE McGimpsey

One way:

Assume the target column is B. Select the rows to C, with the active
cell in row 1, then use

CF1: Formula is =$B1 = "Complete"
Format1: <font>/<lt grey>
 
M

Maax

Hi JE, sorry i am a little ne to formula's in Excel. Can you please advise
what you mean by CF1:

The column that will have "complete" in it will be M. The first row is 3.

I am unsure what the CF: actually refers too?


Max
 
D

Don Guillett

Look at it again and think about it. Could possibly be "conditional
formatting 1"
 
M

Maax

Many Thanks J, as I am a novice i never actually knew there was a drop down
for entering formula in the conditional formatting.

Once i found that it was easy.

Many thanks for your patience.
 
Top