View Single Post
  #2   Report Post  
Leo Heuser
 
Posts: n/a
Default

Ed

One way:

1. Select B30
2. Hold <Ctrl
3. Select D30, F30 and H30
4. Release <Ctrl

Choose "Conditional formatting" and enter
the formula:

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

Choose a formatting.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Edward O'Brien" skrev i en meddelelse
...
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