Hi,

Am Tue, 06 Feb 2018 16:19:58 +0000 schrieb Terry Pinnell:

By selecting B6 and applying Claus's macro below I get the correct
result displayed (having merged a few cells).

https://www.dropbox.com/s/rhikeaorb7...als-3.jpg?dl=0

But how can I do that with a formula instead please?

a formula can't change a format. But you could try the formulas in the
conditional formatting.

BTW, I can no longer reach the link Claus originally provided about this
macro:

I uploaded the workbook again:
https://1drv.ms/x/s!AqMiGBK2qniTgcFwk6ClS7kz-lZnvQ



Regards
Claus B.
--
Windows10
Office 2016