LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 26
Default Cell color formula

I would like a formula to change colors in cells B1-BX based on the values of
cells A1-AX, which are percentages from 0% to 100%. So, if A5=100%, B5 would
be absolute Red. If A6=99%, B6 would be just a little less red and if
A94=0%, B94 would be white.
Thanks
Lafayette, LA
 
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
If Formula to change cell color Nora Najem Excel Discussion (Misc queries) 2 October 12th 06 12:58 PM
color a cell with a formula in it? Ken Excel Worksheet Functions 5 June 12th 06 07:40 AM
need formula to add cell sums by color of cell Brucet Excel Discussion (Misc queries) 2 December 29th 05 09:46 PM
Formatting a cell for color that has a formula also Karl Excel Discussion (Misc queries) 2 July 17th 05 12:03 AM
Cell color change in formula Layth Excel Worksheet Functions 2 February 22nd 05 06:54 PM


All times are GMT +1. The time now is 08:50 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"