Trouble with Conditional Formatting a Range of Cells 1

[JOEYB99]

I am using Excel 2007, and want to conditionally format a range of cells based on the value of a cell within that range. The range is $A$1:$K$2 and my formula states that "=K2>0.99".

I know how to do this but my resulting format condition is only applied to the very first cell of that range, A1.

Why is that? What am I doing wrong?

 

[SkipVought]

hi,

if the expression ONLY refers to one cell, then you have to make the expression for only one cell (absolute), otherwise it is just as if you copied this experssion and pasted it into each cell in a range: that is RELATIVE.
[tt]
=$K$2>0.99
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[JOEYB99]

Thank you for the prompt reply Skip. That worked!

Excellent!