Conditional Formatting

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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.