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