You can but it is flawed as a colour change does not trigger worksheet
recalculation

Function GetColorindex(rng As Range)
GetColindex = rng.Interior.Colorindex
End Function

=If(GetColorindex(A2)=3,1,0)



--

HTH

RP
(remove nothere from the email address if mailing direct)


"nickclingan"
wrote in message
...

Hi, and thanks in advance for considering my question. Basically I need
to be able to sum a range of values in a very large spreadsheet based on
whether or not the cells have a fill color. I've tried looking up the
help files on if and sumif but they don't specify whether or not this
is possible... Anyone know? :)


--
nickclingan
------------------------------------------------------------------------
nickclingan's Profile:
http://www.excelforum.com/member.php...o&userid=28623
View this thread: http://www.excelforum.com/showthread...hreadid=482862