The CF need to be specific to each cell. To that end you do not want absolute
referencing.

Highlight Cells I2:I82 (with I2 as the active cell)
Add this formula for the CF
=AND(I2<"",I2=0.95)
Green

Do the same for Red.
This is a relative referenced function so that it will be correctly
referenced for each cell in the range selected.

--
HTH...

Jim Thomlinson


"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,