VBA: How do I use IF formula with colours

[Helen]

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

 

[Charlie]

If Cells(1, 1).Interior.ColorIndex = 1 Then

-or-

If Cells(1, 1).Font.ColorIndex = 1 Then

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Bob Phillips]

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)

 

[Rick Rothstein \(MVP - VB\)]

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