Read the link that Bob provided... that is probably more along the lines of
what you are after than what I assumed in my posting.
Rick
"Rick Rothstein (MVP -
VB)" wrote in
message ...
Something like this maybe (change the cell reference and what you are
returning the Yes/No to to suit your needs)...
If Range("A1").Interior.ColorIndex < 0 Then
Answer = "No"
Else
Answer = "Yes"
End If
Rick
"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