Conditional Formatting In a Range

I have a spreadsheet with data from A2 through k95. I want to check cell d2
through d95 and if it is greater than 11 I want to format the whole row (a-K)
as blue. I am having trouble with the range. Could you please help.
Thanks,
Mike

Select rows A2:K95. Make sure you select A2 first.

Format -> Conditional format
Formula is =$A2>11

Set your background color as you like.


"mikesteven" wrote:

> I have a spreadsheet with data from A2 through k95. I want to check cell d2
> through d95 and if it is greater than 11 I want to format the whole row (a-K)
> as blue. I am having trouble with the range. Could you please help.
> Thanks,
> Mike