Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 7th 04, 07:55 AM
Bill Brehm
 
Posts: n/a
Default 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



  #2   Report Post  
Old December 7th 04, 09:37 AM
Bob Phillips
 
Posts: n/a
Default

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






Reply
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
how do i use multiple conditional formats in one cell? tysonstone Excel Discussion (Misc queries) 1 January 21st 05 11:15 PM
How do I set more than 3 conditional formats in Excel Reefshark Excel Discussion (Misc queries) 1 January 17th 05 11:57 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM
Conditional Formats in Excel DaveB Excel Worksheet Functions 2 November 15th 04 07:36 AM
copying conditional formats to a whole column Markitos Excel Worksheet Functions 0 November 1st 04 11:23 PM


All times are GMT +1. The time now is 12:52 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017