LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
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
Fill background color automatically by typing a letter in a cell Myke Excel Discussion (Misc queries) 5 April 22nd 23 12:10 AM
change background row color with change of date in a cell Urszula Excel Discussion (Misc queries) 5 May 17th 06 07:56 AM
background color of my cell does not change Colorblinded Excel Discussion (Misc queries) 2 March 27th 05 04:55 PM
automatically changing the background color of a cell martin Excel Programming 8 January 6th 05 11:00 AM
Change Cell-Background color into Text Kai Tücking Excel Programming 1 October 13th 04 03:20 PM


All times are GMT +1. The time now is 09:38 AM.

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

About Us

"It's about Microsoft Excel"