View Single Post
  #3   Report Post  
 
Posts: n/a
Default

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