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