View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dennis dennis is offline
external usenet poster
 
Posts: 202
Default 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