colour of a row depending on cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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>
 
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
 
Look at it again and think about it. Could possibly be "conditional
formatting 1"
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change background colour of a row if a particular cell has a value 1
Question about conditional formatting of zeros in Excel 0
Changing font colour to red & orange 1
format cells depending on value range 5
Insert blank row after change in cell value not working. 1
Conditional formatting in Excel 2010 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel 2003: Keeps applying auto-font settings I don't want 1

Back
Top