Conditional Formatting

Closed
jacob - Jan 14, 2010 at 02:31 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jan 14, 2010 at 05:50 AM
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

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Jan 14, 2010 at 05:50 AM
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.
0