Conditional formatting to hilight minimum value

N

Neal

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

Regards, Neal
 
B

Bob Phillips

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)
 
D

drabbacs

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
 
N

Neal

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
 
B

Bob Phillips

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)
 
N

Neal

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
 
Top