Hi, Andy.

Thanks for the quick reply

It almost works. It highlighted two cells - B30 and H30 - although B30 is a
higher figure.

Any ideas?

Ed





<Andy B wrote in message ...
Hi
Highlight the four cells (B30, D30, F30, H30) in that order and try
something like:
Formula is
=H30=MIN(B30,D30,F30,H30)

--
Andy.


"Edward O'Brien" wrote in message
...
I have 4 columns of figures B, D, F and H with 4 totals: B30, D30, F30 and
H30.

Can anyone give me a formula within "Conditional Formatting" that will
highlight the cell (say in pale blue) with the lowest total of the four?

Thanks in advance

Ed