Blank cells would not turn green with the condition =I20.95
but you would get green if the cell contains a string, even the zero length
string =""
--
David Biddulph

"Go Bucks!!!" wrote in message
...
The second formula, =AND(I2<"",I2=0.95) worked.

If not, the blank cells turned green.

Thank you,

Steve




"Jacob Skaria" wrote:

You dont need a third condition...

Just the formula
=I20.95
is enough

OR
=AND(I2<"",I2=0.95)


If this post helps click Yes
---------------
Jacob Skaria


"Go Bucks!!!" wrote:


Its working, but blank cells are green. Do I need to make a third
condition
with
=""

?



"Jacob Skaria" wrote:

Conditional formula sets the formula to all cells in the selection
automatically. You dont need to refer that in your formula. Just
select the
cells say I2:I82 and enter these formulas in CF conditions

=AND(I2<"",I2<0.95)
Formatting is Red

=(I2=0.95)
Formating is Green

If this post helps click Yes
---------------
Jacob Skaria


"Go Bucks!!!" wrote:

Good morning Jacob,

The result was that all cells turned green (including blanks and
values
below 95%). I am applying the condition to a selection, so the
formula
currently looks like this...


=($I$2:$I$82=0.95)
Formating is Green

=AND($I$2:$I$82<"",$I$2:$I$82<0.95)
Formatting is Red


"Jacob Skaria" wrote:

1. Select the range. Suppose it is column F. The cell which is
referenced in
the formula is the active cell in the selection. Active cell will
have the
white background even after selection.

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=AND(F1<"",F1<0.95)
Click Format ButtonPattern and select your color (say Red)

4. Click on Add button.

5. For Condition2Select 'Formula Is' and enter the below formula
=F1=0.95)

Click Format ButtonPattern and select your color (say Green)

6. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Go Bucks!!!" wrote:

I need to conditionally format cells based on their value.
These values are
in percent. I want the following conditional formating rules:

blank = no formating, <95% Red, 95% Green

Thanks,