logical expressions of formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

will seymour - 17 Apr 2008 22:42 GMT

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

Reply to this Message

Dave Peterson - 17 Apr 2008 23:22 GMT

You'll need some VBA.

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

> 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
[quoted text clipped - 3 lines]
> will place a 1 in the destination cell when A5 is blue I just have no idea
> how to reference the format

Signature

Dave Peterson

Reply to this Message