View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jock Jock is offline
external usenet poster
 
Posts: 440
Default MAX from different columns

Having trouble with this.
I am trying to find the MAX value from (C3:C6,F3:F5) but can't get it to work.
Essentially, it's a list split over two columns from which I'd like the Max
highlighted using conditional formatting.

Thanks
--
Traa Dy Liooar

Jock