View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1628_] Rick Rothstein \(MVP - VB\)[_1628_] is offline
external usenet poster
 
Posts: 1
Default How do I use IF formula with colours

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