Can you do an IF function whether a cell has a fill color of Rose

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to get a 1 returned when I quere a cell if the fill color is Rose
(colorindex=38). Do you use the IF function or is there another way to do
it? What is the IF function syntax?
 
Yes, you would use an IF function but one in VBA. And the result can be
anything you want in any cell you want. But if you could provide a bit more
information about what you have and what you want to have, perhaps there are
other, better, ways to get what you want. For instance, where did the Rose
color come from, or how did it get there? HTH Otto
 
Enter this small UDF:

Function clr(R As Range) As Integer
With R.Interior
clr = .ColorIndex
End With
End Function

and use in the worksheet like =clr(A1)
 
Back
Top