Highlighting cells that exceed a specified value

  • Thread starter Thread starter Brian
  • Start date Start date
B

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
 
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
 
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.





.
Click to expand...
 
Back
Top