Changing Font Colour of row depending on selection made in 1st col

Changing Font Colour of row depending on selection made in 1st col

Post by QnVuZHl1dG » Fri, 10 Oct 2008 12:05:01


I am currently trying to work out how to change the font colour of all cells
in the row, depending on the selection made from a list in the 1st column
(Col. A).
Column A is based on selecting from a List, with about half of the
selections already conditionally formatted to a certain colour.

My question is - how can I get the other cells in the row to change to the
same colour as the selected cell? Given that the list contains 17 different
cells to select from, and 10 of these when selected display as a different
colour.

Currently I am manually selecting the row and changing the font colour, but
would like to have it done automatically.

Any help will be most welcomed.

Cheers.
 
 
 

Changing Font Colour of row depending on selection made in 1st col

Post by AltaEg » Fri, 10 Oct 2008 13:15:06

You seem to wish to conditionally format a row based on column A. If so, you
need to create a conditional format formula rather than use 'value is'. This
should help:

http://www.yqcomputer.com/

Debra even has a video to show you how.

If you get stuck, don't hesitate to write back outlining your problem.

--
Steve