Excellent news.

Thanks for the feedback




On Sat, 14 Jul 2007 17:54:53 GMT, Paul Hyett
wrote:

In microsoft.public.excel.misc on Sat, 14 Jul 2007, Paul Hyett
wrote :
In microsoft.public.excel.misc on Fri, 13 Jul 2007, Gord Dibben
wrote :

On Fri, 13 Jul 2007 17:35:02 GMT, Paul Hyett
wrote:

OK - this does work, but I have several hundred rows of figures*, and
IIRC you can only have around 3 conditional formats on one spreadsheet?

Make that 3 CF per cell, not worksheet.

Gord Dibben MS Excel MVP

Thanks - either that is different for the latest versions of Excel, or
I misinterpreted something previously.

Worked like a charm - I just had to change the absolute row reference to
a relative one, then copy it down all the rows I needed! :)