Hi Jock,

=MAX(C3:C6,F3:F5)

works fine for me

What problem do you have?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jock" wrote in message ...
| 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