Re: FormatConditions(1).Formula1

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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)
  • Re: Application.ontime from shared drive
    ... Once your workbook is opened in excel, it doesn't matter where it came from. ... But depending on what your macro does, maybe that won't work on a shared drive ...
    (microsoft.public.excel.misc)
  • [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)
  • 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)