Posted to microsoft.public.excel.programming

will seymour will seymour is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get rid of with regular expressions	Howdy	Excel Discussion (Misc queries)	1	January 18th 10 07:42 PM
Regular expressions	Dave	Excel Programming	5	September 20th 07 02:46 PM
Regular Expressions	sl	Excel Programming	2	January 22nd 07 11:27 PM
Regular Expressions in VBA?	Rob[_23_]	Excel Programming	13	February 10th 05 05:34 AM
[VBA] Score expressions and SUM them	McD-nl	Excel Programming	2	September 12th 04 03:21 PM

All times are GMT +1. The time now is 09:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us