Cheers. If I was to use the CFColorCount bit, what code would I need to put
in the before save bit?

Do I use Call and call it and then set the range? And then say if the total
is greater than 0 there's an error?

Ta,

cdb

"Bob Phillips" wrote:

If you know how to do it for manual fill, see
http://www.xldynamic.com/source/xld.CFConditions.html to learn how to get it
for CF, but beware, it is not trivial.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"cdb" wrote in message
...
I have a spreadsheet with some conditional formatting in to highlight rows
where a duplicate NI Number has been entered. As it is highlighting the
row,
there is conditional formatting behind each cell.

What I need is some code to show which cells have had their interior
colour
changed due to conditional formatting before a save.

ie When the workbook is saved, it goes through all the cells on the
spreadsheet (A3:AA1000) and if the interior colour of a cell in Column S
has
been changed due to conditional formatting an error will pop up and
prevent
the save.

I managed to get this work for a manually changed cell, but not one
changed
due to conditional formatting as it still treats it as no fill.

All help would be greatly appreciated.

cdb