View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BOLS BOLS is offline
external usenet poster
 
Posts: 1
Default 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