Using cell color as condition in equation
 

Can you identify a cell color as a condition in a "Countif" function

Using cell color as condition in equation
 

John have a look here http://www.cpearson.com/excel/colors.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

"John31" wrote in message
...
Can you identify a cell color as a condition in a "Countif" function

Using cell color as condition in equation
 

John,

Not directly because CountIf checks the value property of
a cell and not another property (like color, font, etc.)

Skip.

-----Original Message-----
Can you identify a cell color as a condition in
a "Countif" function
.