-
change font colour in a row according to cell value
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
-
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:
Then set your formatting
Does this help?
-
thats perfect mate
Thank you
Bacon
-
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
and format is required.
Goto Add>>> and add the second condition.
-
Good put, well point Norie!
You're welcome Bacon.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules