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
|