logical expressions of formats
 

I am trying to create an if statement that will count a cell it the font is a
particular color, I just don't know the syntax of the logical expression

ex
if(A5.font = "blue"), 1, " ")
will place a 1 in the destination cell when A5 is blue I just have no idea
how to reference the format

logical expressions of formats
 

You'll need some VBA.

Chip Pearson explains it he
http://cpearson.com/excel/colors.aspx

will seymour wrote:

I am trying to create an if statement that will count a cell it the font is a
particular color, I just don't know the syntax of the logical expression

ex
if(A5.font = "blue"), 1, " ")
will place a 1 in the destination cell when A5 is blue I just have no idea
how to reference the format

--

Dave Peterson