Any way to have more than three conditional formats?
We would like to set the background color of cells depending on their
values. But the number of legitimate values is higher than three. There are at least five legimate values plus it would also be nice to display illegimate values yet another color. Any tricky ways, like having a legend on the spreadsheet and looking up and applying the background color from the legend? Thanks, Bill |
Bill,
This needs event code. There is a free addin that does this at http://www.xldynamic.com/source/xld.....Download.html -- HTH RP (remove nothere from the email address if mailing direct) "Bill Brehm" <don't want any spam wrote in message ... We would like to set the background color of cells depending on their values. But the number of legitimate values is higher than three. There are at least five legimate values plus it would also be nice to display illegimate values yet another color. Any tricky ways, like having a legend on the spreadsheet and looking up and applying the background color from the legend? Thanks, Bill |
All times are GMT +1. The time now is 12:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com