A

#### AdmiralAJ

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