Conditional Formatting

[Closed]
Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I got the following scenario.

We need to put colors to columns

If our SLA >= 99.50% must be Green
If our SLA < 99.50% but >= 98.00% if must be Purple
If our SLA < 98.00% if must be Red

The formulae for the above percentage are in G4, and the color for conditional formatting must be in H4

Can you please help with this

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
In the conditional formatting window of H4use "the formula is"(instead of value is)
in the formula windowa
=g4>=.995 and click format and choose patterns and choose green
click ok once
then in the conditional format window
click add
and in the condition 2 type the otehr formula
choose formt-patter-color
click ok once
and again repeat the same for the third formula
click ok twice
in excel upto verions 2003 you can have only three conditions.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!