Conditional formatting to hilight minimum value

  • Thread starter Thread starter Neal
  • Start date Start date
N

Neal

Can Conditional formatting do this? I have eight cells, and want to
highlight the lowest value in red.

Regards, Neal
 
Of course, condition 1 of Formula is, formula of =MIN($A$1:$A$8), and format
as desired.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Sure.

Select the 8 cells( example A1 to A8), go to the
conditional formatting menu. Enter "cell value", "is equal
to" , =min(A1:A8) and then set you format to red.
Substitute your range for A1 to A8.

Drabbacs
 
Hmm, I'm having problems because my cells are not together. I have cells
H8, H13, H18, H23.

I have also tried to name these cells, and to use the name in the formula.

I think the problem is related to only selecting those cells before going to
Format, Conditional Format.

Thanks for your advice, Neal
 
Neal,

Shouldn't be any different, select those 4 cells, make sure that H8 is
active, and use a formula of
=H8=MIN($H$8,$H$13,$H$18,$H$23)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Well well well, it all depends on making H8 active, before going in to
Conditional Formatting!
I was selecting from left to right, and ending up on the last cell.

Oh yeah, and I was actually working across a row, not as I said.

Thanks heaps!

Purbeck as in the South of England? I went to Purbeck and bought a
sailplane from a company called Purbeck Sailplanes!

Neal
 
Back
Top