Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting Weirdness
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.) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting Weirdness
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting Weirdness
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP weirdness | Excel Worksheet Functions | |||
Conditional Sum weirdness . . . | Excel Worksheet Functions | |||
VBE Weirdness | Excel Programming | |||
Weirdness | Excel Programming | |||
VBA IDE Weirdness.... | Excel Programming |