View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Conditional Formatting In a Range

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

Format - Conditional format
Formula is =$A211

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