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" wrote in message
...
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" wrote in message
...
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