 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Conditional formatting - progressively darker/lighted shading
Is it possible to shade fields progressively darker or lighter depending on the values. For example, I would like the following values to have the following colours: -5 dark red -4 lighter red -3 slightly lighter red -2 etc, etc 1 light green 5 dark green One step further - would it be possible to tell excel to work out which is the lowest and highest number in the data set and work out for itself how light or dark to shade the values e.g, if my dataset happened to have the values -50, -40, etc excel would work out which was a low value and which was a high one. Conditional formatting would normally be used to do this. However, in XL2003 and earlier versions, you are limited to a maximum of 3 conditional formats per cell, so you would have to develop a macro to give you the range of colours you describe. I did this for a client some time ago with seven colour bands, and to be honest the effect was not as dramatic as he had hoped. The MIN( ) function can find the lowest value in a range and MAX( ) the highest, so you could use these to scale your data. Hope this helps. Pete > Is it possible to shade fields progressively darker or lighter depending on > the values. For example, I would like the following values to have the [quoted text clipped - 11 lines] > values -50, -40, etc excel would work out which was a low value and which was > a high one. Many thanks Pete > Conditional formatting would normally be used to do this. However, in > XL2003 and earlier versions, you are limited to a maximum of 3 [quoted text clipped - 25 lines] > > values -50, -40, etc excel would work out which was a low value and which was > > a high one. You're welcome - thanks for feeding back. Pete > Many thanks Pete > [quoted text clipped - 29 lines] > > - Show quoted text - Hi Jonny, Sounds like a job for Superman!! While you are waiting, Bob Phillips does a very good impression with his CF Plus. It allows for up to 30 conditional formats. Click here, http://xldynamic.com/source/xld.CFPlus.Download.html HTH Martin > Is it possible to shade fields progressively darker or lighter depending > on [quoted text clipped - 13 lines] > was > a high one.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.