Conditional Formatting In a Range

M

mikesteven

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
 
B

Barb Reinhardt

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

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

Set your background color as you like.
 
Top