logical expressions of formats

  • Thread starter Thread starter will seymour
  • Start date Start date
W

will seymour

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing font color based on type cell it is. How to do it? 6
Conditional formatting with vba 3
conditional format - table - cell empty return default color 1
If Function with Text Formatting 5
Counting Cells which have Bold & Red Strike Effect Through Conditional Formatting 2
code to color cell 1
Copying a conditional formating rows with text and values 2
Create formulas in conditional formatting 2

Back
Top