Highlighting cells that exceed a specified value

[Brian]

Howdy all,

I have a list of data in cells b3:b103, and I would like
to input a maximum value criteria in cell a1. Then I would
like any value in cells b3:b103 that exceed this specified
value in a1 to be highlighted and for cell a1 to highlight
as well to flag that there is indeed an excessive value
amongst the data.

Thank you for your time and attention.
Brian

 

[Roger Whitehead]

Hi Brian,

Check out OLH for Conditional Formatting

 

[Andy B]

Hi

Use Format / Conditional Formatting.
Select the range of numbers and in CF use Cell Value is greater than and
enter A1 . Select a pattern and click OK
Select cell A1 and in the CF, select Formula is and put in
=MAX(B3:B103)>A1
Pick your pattern and click OK

 

[Brian]

Thanks Andy, that worked perfectly!!

Brian

-----Original Message-----
Hi

Use Format / Conditional Formatting.
Select the range of numbers and in CF use Cell Value is greater than and
enter A1 . Select a pattern and click OK
Select cell A1 and in the CF, select Formula is and put in
=MAX(B3:B103)>A1
Pick your pattern and click OK


--
Andy.





.

 

[Andy B]

Thanks for the feedback!

--
Andy.

Thanks Andy, that worked perfectly!!

Brian