change font colour in a row according to cell value

[bacon]

Hello


I need some help please with an excel problem I have.

I want to be able to select from a list a value (Action or Proposal) If the cell value is Action i would like the rest of row to have a red and bold font. If it is Proposal then the font to be black for the row.

The action/proposal cell will be the first cell in the row....

I know how to make a list I am just struggling with the changing the font colour.

Does anyoine have any ideas how to do this. Conditional formatting only works with one cell...

Many thanks

Bacon

[Sir Babydum GBE]

Hi Bacon

Conditional formatting actually is the answer! It will work with more than one cell.

(assuming that A1 has "Action" in it, and you want B1 to change format) Select cell B1 and start the Conditional Formatting process. Change "Cell Value is" to "Formula is". then, in the formula box type:

=$A$1="Action"

Then set your formatting

Does this help?

[bacon]

thats perfect mate



Thank you


Bacon

[Norie]

If you want conditional formatting to work on an entire row(s) select the rows and goto Conditional Formatting.

Choose formula is from the dropdown, enter

=$a1="Action"

and format is required.

Goto Add>>> and add the second condition.

[Sir Babydum GBE]

Good put, well point Norie!

You're welcome Bacon.