I am using Excel 2007 and have tried using conditional formatting to
format a cell's number format based on a condition in an adjacent cell
but its not working and would love any input on what I'm doing wrong.

Here's what I'm doing:

A1 B1
1 or 0 2 conditional formatting rule(s):

I'm choosing:
Conditional Formatting---New Rule---"Use a formula to determine
which cells to format" --- (then in the description box I type this
formula) =A1=1. If this condition is true format as %.

I then create a 2nd rule following the same steps above except that
the formula now reads =A1=0. If this condition is true format as
Currency.

When I do this is always shows % formatting even if A1=0. I cleared
all and then tried again, didn't work. Then I cleared all again, then
I formatted the cell as % and then just adding the 2nd rule mentioned
above and I get the same problem. I also tried formatting the cell as
currency and then adding rule 1 only and still the same problem.

Any insight would be appreciated...AJ