Russ At Index
Well-known Member
- Joined
- Sep 23, 2002
- Messages
- 706
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hello Excel World ,
Once again the management have tasked something & i really don't know where to begin .. so here goes.
A table detailing number of sales from each location . So each cell has a number within it (or it is blank if the
formula result is 0). These cells have been conditionally formatted into four "static" conditions:
Cell value is blank = Blue
<50 = Red
>50,<100 = Amber
>100= Green
So four conditions , and it works perfectly .
Powers that be would like to be able to re model the formatting , for example change the less than , greater than
quantities but keep the same colours.
My question is , is there any way to either dynamically change the rule , or is there an option to have several rules
and you could select that rule ?.
Any ideas , as always gratefully received..
Many thanks ,
Russ.
Once again the management have tasked something & i really don't know where to begin .. so here goes.
A table detailing number of sales from each location . So each cell has a number within it (or it is blank if the
formula result is 0). These cells have been conditionally formatted into four "static" conditions:
Cell value is blank = Blue
<50 = Red
>50,<100 = Amber
>100= Green
So four conditions , and it works perfectly .
Powers that be would like to be able to re model the formatting , for example change the less than , greater than
quantities but keep the same colours.
My question is , is there any way to either dynamically change the rule , or is there an option to have several rules
and you could select that rule ?.
Any ideas , as always gratefully received..
Many thanks ,
Russ.