LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to apply same format of referenced cell in Excel Steven Brassem Excel Discussion (Misc queries) 0 September 21st 06 01:14 PM
Reformating a column and getting it to apply Thansal New Users to Excel 2 July 7th 06 03:04 PM
'Centre across selection' format to apply to vertical range Shrikant Excel Discussion (Misc queries) 3 September 27th 05 09:24 AM
How to apply a format to an entire workbook mdeanda Excel Worksheet Functions 0 May 17th 05 06:17 PM
How to apply a format to an entire workbook Peo Sjoblom Excel Worksheet Functions 0 May 17th 05 06:11 PM


All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"