ExcelBanter - Conditional Formatting In a Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formatting In a Range (https://www.excelbanter.com/excel-discussion-misc-queries/99175-conditional-formatting-range.html)

mikesteven

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

Barb Reinhardt

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

All times are GMT +1. The time now is 06:26 PM.