software

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?

See www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Kays Excel Questionquot; lt;Kays Excel gt; wrote
in message news
gt; I want to get a 1 returned when I quere a cell if the fill color is Rose
gt; (colorindex=38). Do you use the IF function or is there another way to do
gt; 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
quot;Kays Excel Questionquot; lt;Kays Excel gt; wrote
in message news
gt;I want to get a 1 returned when I quere a cell if the fill color is Rose
gt; (colorindex=38). Do you use the IF function or is there another way to do
gt; it? What is the IF function syntax?
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)
--
Gary''s Studentquot;Kays Excel Questionquot; wrote:

gt; I want to get a 1 returned when I quere a cell if the fill color is Rose
gt; (colorindex=38). Do you use the IF function or is there another way to do
gt; it? What is the IF function syntax?