Conditional formatting
I'm working on graphs showing the trends of consumables in a mineral
processing plant. I've attached smileys on the charts and want these to
change colour according to whether the consumption is below or above target.
For example, I want the smiley to turn green when the trend is good and red
when the consumption is above target.
thanks people
|