Thread
:
Cell color based upon cell value
View Single Post
#
8
Bob Phillips
Posts: n/a
Yep!
--
HTH
Bob Phillips
"My View" <reply to
wrote in message
...
Does this have to be installed on all PCs that open the spreadsheet?
"Bob Phillips" wrote in message
...
See
http://www.xldynamic.com/source/xld.....Download.html
--
HTH
Bob Phillips
"My View" <reply to
wrote in message
...
I know you can use Conditional Formatting to allocate a colour for a
cell
value but you are limited to 4 alternatives (ie the default cell color
and
only 3 variations in Conditional Formatting).
How can I allocate a different color for 5 different cell values?
For example:
If cell value = 1 then cell color is green
If cell value = 2 then cell color is blue
If cell value = 3 then cell color is yellow
If cell value = 4 then cell color is red
If cell value = 5 then cell color is magenta
regards
PeterH
Reply With Quote