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

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