| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get rid of with regular expressions | Excel Discussion (Misc queries) | |||
| Regular expressions | Excel Programming | |||
| Regular Expressions | Excel Programming | |||
| Regular Expressions in VBA? | Excel Programming | |||
| [VBA] Score expressions and SUM them | Excel Programming | |||
Linear Mode
