Re: FormatConditions(1).Formula1

Hi Tom,

I tried Chip's macro and it failed because of not handling FormulaLocal
(just like Bob's one)!

Regards,
Stefi



„Stefi” ezt írta:

Thanks Tom,

I know that my formula is applicable only for a simple case, but for the
moment I have only that simple case, and I was glad to solve my present
problem.

Many thanks for your guiding me to Chip's page, now I have an abundant
choice of solutions, including Bob's one, I am going to test them, paying
special attention to handling FormulaLocal, because
ActiveCell.FormatConditions(1).Formula1 returns formulae in Local format in
national language versions.

Regards,
Stefi


„Tom Ogilvy” ezt írta:

Check out Chip Pearson's page on this topic:

http://www.cpearson.com/excel/CFColors.htm

For your function,
Depending on your formula, I am not sure it is a general solution.

--
Regards,
Tom Ogilvy

"Stefi" <Stefi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:77E2759C-3450-4823-AAA3-FA48F9E34758@xxxxxxxxxxxxxxxx
Hi Bob,

Sorry for my poor English! I'd like to know wether the formula in
ActiveCell.FormatConditions(1).Formula1 gives True or False!

In the meantime I made a solution:

Function FormCondTF(fcformulaLoc, workcell)
Range(workcell).FormulaLocal = fcformulaLoc
FormCondTF = Range(workcell)
Range(workcell).ClearContents
End Function

Answer = FormCondTF(ActiveCell.FormatConditions(1).Formula1, "Z1")

But I'm still interested in your opinion!

Regards,
Stefi

"Bob Phillips" ezt írta:

Pardon? What does the question mean?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Stefi" <Stefi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B234DD9-92B9-406A-97FB-C67250086FE2@xxxxxxxxxxxxxxxx
Hi All,

It is known that
ActiveCell.FormatConditions(1).Formula1
returns the formula as a string.

How can I ask if this formula fulfils for ActiveCell (or another cell)
or
not?

Thanks,
Stefi







.

Relevant Pages

  • Re: Getting source lists w/o opening target file
    ... This macro returns a the list of files that the document is linked do (it ... Probably depending on how the link was created. ... >> We need a method to extract the list of documents an excel document is ...
    (microsoft.public.excel.programming)
  • Deleting lines with a variable.
    ... In my macro I want to delete some lines depending on a test. ... I loop through some lines and do a check whether to delete the line. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • [PATCH 1/1] Add missing include into include/linux/netdevice.h
    ... Depending on configuration options, the latter ... is either defined as a macro or is declared as a function in another header ...
    (Linux-Kernel)
  • Re: user defined name to save a document based on a template
    ... a generic name like "Document 1" or the like, depending on the ... then put that into thetemplate'sTitle field and the documents will inherit it. ... You can put a macro in thetemplatethat sets the Title field for each document ...
    (microsoft.public.word.vba.general)