samibo
New Member
- Joined
- Feb 11, 2011
- Messages
- 49
Hi
I'm trying to apply icon sets to my data through conditional formatting.
Using the Edit Formatting rule I'd like to do the following:-
Green Tick for >= 1% and <= 3.49%
Yellow Marker for >= 3.50% and <= 4.39%
Red Tick for >= 4.4%
The problem I'm having is that it still gives an icon to 0%.......I don't want this.
You cant seem to be able to add just one icon to 1 rule.
Any ideas or am I missing something really simple?
Thanks
I'm trying to apply icon sets to my data through conditional formatting.
Using the Edit Formatting rule I'd like to do the following:-
Green Tick for >= 1% and <= 3.49%
Yellow Marker for >= 3.50% and <= 4.39%
Red Tick for >= 4.4%
The problem I'm having is that it still gives an icon to 0%.......I don't want this.
You cant seem to be able to add just one icon to 1 rule.
Any ideas or am I missing something really simple?
Thanks