Here's another...conditional formatting has been "glitching" around a
lot, as well. Have you noticed anything weird with this? I have
tried the conditional formatting provided in the program and created
it on my own with the cell.

For example:
=if("D4="Years",E4/F4,text(E4/F4,"0.0%"))

This formula works most of the time, but just stops working in some
instances until you edit the formula, altering nothing, and
recalculate. Same with the conditional formatting functionality built
into excel. (Note: I have already verified uniform formatting of
the
source date.)

Jim laid this down on his screen :
> Here's another...conditional formatting has been "glitching" around a
> lot, as well. Have you noticed anything weird with this? I have
> tried the conditional formatting provided in the program and created
> it on my own with the cell.
>
> For example:
> =if("D4="Years",E4/F4,text(E4/F4,"0.0%"))
>
> This formula works most of the time, but just stops working in some
> instances until you edit the formula, altering nothing, and
> recalculate. Same with the conditional formatting functionality built
> into excel. (Note: I have already verified uniform formatting of
> the
> source date.)

This is not a Conditional Formatting formula as would be used in the CF
dialog. Please restate your problem if you expect any helpful
suggestions.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

You have another response at one of your other posts.

On 09/16/2010 10:47, Jim wrote:
> Here's another...conditional formatting has been "glitching" around a
> lot, as well. Have you noticed anything weird with this? I have
> tried the conditional formatting provided in the program and created
> it on my own with the cell.
>
> For example:
> =if("D4="Years",E4/F4,text(E4/F4,"0.0%"))
>
> This formula works most of the time, but just stops working in some
> instances until you edit the formula, altering nothing, and
> recalculate. Same with the conditional formatting functionality built
> into excel. (Note: I have already verified uniform formatting of
> the
> source date.)

--
Dave Peterson