PDA

View Full Version : [SOLVED] change font colour in a row according to cell value



bacon
03-22-2005, 02:45 AM
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
03-22-2005, 03:52 AM
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
03-22-2005, 04:47 AM
thats perfect mate


:beerchug:
Thank you


Bacon

Norie
03-22-2005, 05:55 AM
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
03-22-2005, 07:39 AM
Good put, well point Norie!

You're welcome Bacon.