just use formatconditional format

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AussieBumBxl" wrote in message
...
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