Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell Background color Automatically
I have an Excel spreadsheet with 100 rows and 4 columns. The four columns
have percentage values in them. The question is this: I would like to write a program that will compare the values in each rows corresponding columns and turn the background color of the cell with the higher percentage value to a desired color such as green. I have done very little VBA but should be able to handle this simple task. Please include any code. I am very new at Excel. Thanks -- Dennis B |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Cell Background color Automatically
You don't need VBA, conditional formatting will do it.
In CF, use a formula of =A1=MAX(1:1) For an intro to CF, see See http://www.contextures.com/xlCondFormat01.html -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Dennis" wrote in message ... I have an Excel spreadsheet with 100 rows and 4 columns. The four columns have percentage values in them. The question is this: I would like to write a program that will compare the values in each row's corresponding columns and turn the background color of the cell with the higher percentage value to a desired color such as green. I have done very little VBA but should be able to handle this simple task. Please include any code. I am very new at Excel. Thanks -- Dennis B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill background color automatically by typing a letter in a cell | Excel Discussion (Misc queries) | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
background color of my cell does not change | Excel Discussion (Misc queries) | |||
automatically changing the background color of a cell | Excel Programming | |||
Change Cell-Background color into Text | Excel Programming |