View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael.Tarnowski Michael.Tarnowski is offline
external usenet poster
 
Posts: 95
Default How to add traffice light

On Jul 15, 11:52 am, Avadh wrote:
Hi,

I am looking for a solution to add the 2 traffic lights so that get a
Cumulative status.

For eg : red + amber is red
red + green is red
amber + green is amber
red+red is red
amber + amber is red
green + green is green

Thanks in advance,
Avadh


Hi Avadh,
in my eyes it's a question of upper and lower limits.
a.) define upper and lower limits for each traffic light color; assign
the color for all data in these ranges.
b.) define rules for cumulative traffic lights, i.e. cumulation of
these tolerance ranges.

Have fun, cheers
Michael