neilforrow
New Member
- Joined
- Sep 30, 2004
- Messages
- 16
Morning...
have spent some time looking at old posts and cant find what I am looking for...
I am trying to conditional format a sheet, where, if a a value is entered the cell color changes. So using conditional formatting, easy enough...
although I have 7 different values for 7 different colors, and the conditional formatting seems to only cope with 3 sets of values...
Is there a way of setting up multiple (ie more than 3) conditional formatting conditions are.
eg:
NY = Red
HM = Yellow
KH = Green
EG = Blue
etc...
Thanks for the help in advance...
have spent some time looking at old posts and cant find what I am looking for...
I am trying to conditional format a sheet, where, if a a value is entered the cell color changes. So using conditional formatting, easy enough...
although I have 7 different values for 7 different colors, and the conditional formatting seems to only cope with 3 sets of values...
Is there a way of setting up multiple (ie more than 3) conditional formatting conditions are.
eg:
NY = Red
HM = Yellow
KH = Green
EG = Blue
etc...
Thanks for the help in advance...