Hi, Domenic.

No luck, I'm afraid. No highlights atall. I was very careful to get your
formula right and treble checked.

I'm using Excel 97 - does that make any difference?

Ed





"Domenic" wrote in message
...
Try the following...

1) Select/highlight B30

2) Format Conditional Formatting Formula Is

3) Enter the following formula:

=(B30<"")*(B30=MIN($B$30,$D$30,$F$30,$H$30))

4) Choose your formatting, such as 'pale blue'

5) Click Ok

6) Copy the formatting to your other cells (D30, F30, and H30) using the
'Format Painter' or 'Copy Paste Special Formats'.

Hope this helps!

In article ,
"Edward O'Brien" wrote:

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