Thread: VBA: How do I use IF formula with colours
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
  
Posts: 703
Default VBA: How do I use IF formula with colours
If Cells(1, 1).Interior.ColorIndex = 1 Then

-or-

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


"Helen" wrote:

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
Reply With QuoteReply With Quote