Re: Conditional Formating

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

While testing this I experienced some really "messed up stuff" (we usually
call them BUGS)!

I may have spoken too soon on the "bug" issue!

Upon further testing this may be related to an *inadequate* video display
card.

I've experienced this before on my home machine using Excel 2002. It's only
happened 2 times that I can remember and it only happened when trying to set
conditional formatting. The cause is the video card doesn't/can't refresh
fast enough and it leads one to believe that there's a problem with
conditional formatting itself.

If I scroll so the the formatted cells are no longer on screen and then
scroll back the conditional formatting is "magically" applied!


--
Biff
Microsoft Excel MVP


"T. Valko" <biffinpitt@xxxxxxxxxxx> wrote in message
news:uFRhtljaJHA.4684@xxxxxxxxxxxxxxxxxxxxxxx
Hmmm...

While testing this I experienced some really "messed up stuff" (we usually
call them BUGS)!

It works the way you want if...

You enter this condition first: =$A$1 <> "F" and enter this condition 2nd:
=$A$1 = "F"

Or, set a default format of 00.00% and then just use a single conditonal
formatting rule of =$A$1 = "F"

--
Biff
Microsoft Excel MVP


"Jack" <Jack@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6F774044-4245-4F6D-AEE8-634547B7219A@xxxxxxxxxxxxxxxx
I'm trying to set the format for a group of cells based on the value of
another cell - lets say A1

my formula is =$A$1 = "F" format 00.0000 applies to $D$1:$E$2 and
=$A$1 <> "F" format 00.00% applies to $D$1:$E$2

when i set the formual with A1 = "F" and change it the cells change to %
but
when I change A1 back to "F" the cells do not change.

What have i missed.

Jack




.

Relevant Pages

  • Re: The Microsoft Way (OT)
    ... M$ was caught with a "smoking gun" in regards to DR DOS (hidden code that was ... And maybe all that waiting and all thoose bugs is ... This card stated, "Who is the most important person at ... registering, like tech support. ...
    (alt.lang.asm)
  • Re: Regression: misdetected PCMCIA KW-7004 in 2.4.29-pre2
    ... > I have already managed to hit several bugs, ... > removing the PCMCIA card from the slot results in kernel oops: ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • Re: hardware for home use large storage
    ... The virtual media doesn't work at all. ... worst experience with remote management cards. ... I believe that other HP servers with built-in card with different FW is ... I reported this + 8 different bugs of web management interface to Sun ...
    (freebsd-stable)
  • Re: IP spoof messages in firewall logs
    ... I don't know about a "bug" but I do know that if you have two NICs in the ... The primary card handles regular network traffic. ... > One of the SonicWALL support documents mentions that "bugs in Windows ...
    (microsoft.public.win2000.networking)
  • Re: Conditional Formating
    ... call them BUGS)! ... conditional formatting itself. ... If I scroll so the the formatted cells are no longer on screen and then ... Microsoft Excel MVP ...
    (microsoft.public.excel.misc)