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
|