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.
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)