See http://www.xldynamic.com/source/xld.CFConditions.html but it is not
simple.

--
HTH

Bob

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

"Helen" wrote in message
...
I have a spreadsheet that is colour coded, and I want to be able to return
a
yes or no based on whether the cell is coloured in or not.

I'm trying to use If Then with FormatConditions.Colorindex but it's not
working.

Many thanks

Helen