I have a series of cells that will accumulate score totals. Using Conditional Formatting, I want the cells to display the color of ribbon to be awarded to the person or team. Normally ribbons are awarded to the top 9 finishers, but near as I can tell, Conditional Formatting allows only 3 colors.
Is there a way for this to be increased?
May be this link might help?
http://www.personal-computer-tutor.c...v18/chad18.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
OldChippy
Just wanted to let you know that I finally got around to trying this and it worked VERY well! Sorry it took so long to get back to you.
Wow, I'd forgotten all about this one - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks