XL 2003-Formula/Conditional Formatting Question

R

Ross

Hi all

Is there a way in 2003-conditional formatting, maybe??- to say that if a
cell is a certain color, then sum that cell with another??

Thanks!
 
B

Bob Phillips

You would need a UDF to check that cell colour, something like

Function IsColour(rng as range, CI as long)
if rng.Count > 1 Then Exit Function
IsColour = rng.Interior.ColorIndex = Ci
End Function

and use like

=IsColour(A1,3)

testing for red.

You can't use CF to sum, but you can use the technique described here
http://www.xldynamic.com/source/xld.ColourCounter.html
 
R

Ross

Hi Bob

Thanks for the prompt response. I took a look at the page and I gotta tell
ya, I and people like me (non-techies) can only hope MS comes up with
something the rest of us can use! It looks pretty nifty, though.

Do you know if this can be done yet in 2007?
 
Top