How to apply an automatic format to a column?


G

Guest

Hi,

I am trying to automatically apply a format to a column, the colum's color
should change depending the value of a cell on the top of the column.

Ex.:

if A1 value is 1 then apply color RED in cells A2 A3 A4 A5 A6
if A1 value is 2 then apply color GREEN in cells A2 A3 A4 A5 A6

thx for you help.

Arnaud
 
Ad

Advertisements

Ad

Advertisements

G

Gord Dibben

Select A2:A6 and Format>Conditional Formatting>Condition 1>Formula is:

=$A$1=1 Format to Red

Add>Condition 2>Formula is:

=$A$1=2 Format to Green.


Gord Dibben MS Excel MVP
 

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

Top