Hi there,

I am trying to do a conditional format with 4 Colors based on a set of %'s for a tracker we use at work, we currently have to manually light them.

I need them to light when the following % are achieved:-

less than 50% = red
51%-60% = Amber
61-70% = Green
0ver 80% = Blue.

I am quite comfortable in doing conditional formats with 3 however i am total stuck in doing the 4 Conditions, if any one could help that would be great!


Thanks

Justin.