How to apply an automatic format to a column?
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 |
How to apply an automatic format to a column?
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 |
How to apply an automatic format to a column?
Select A2:A6 and FormatConditional FormattingCondition 1Formula is:
=$A$1=1 Format to Red AddCondition 2Formula is: =$A$1=2 Format to Green. Gord Dibben MS Excel MVP On Sat, 18 Aug 2007 06:48:01 -0700, AussieBumBxl wrote: 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 |
All times are GMT +1. The time now is 04:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com