Go to ONLY the first cell B30 goto conditional formating enter the following
formula

=F19=MIN($D$19,$F$19,$H$19,$B$19)

select the format you want. Click OK

The using the format painter (paint brush on toolbar), doouble clikc and
apply to all four cells. Don't forget to press Esc to turn format painter off.

That should do it.

--

_______________________
Naz,
London


"Edward O'Brien" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 <[email protected]>,
> > "Edward O'Brien" <[email protected]> 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
>
>
>