XL 2003-Formula/Conditional Formatting Question
 

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!
--
smither fan

XL 2003-Formula/Conditional Formatting Question
 

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


--
__________________________________
HTH

Bob

"Ross" wrote in message
...
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!
--
smither fan

XL 2003-Formula/Conditional Formatting Question
 

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?
--
smither fan


"Bob Phillips" wrote:

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


--
__________________________________
HTH

Bob

"Ross" wrote in message
...
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!
--
smither fan