On Mar 11, 3:10*pm, "Bob Phillips" wrote:
Are you sure that cell B1 was active when you applied the rule?

--
__________________________________
HTH

Bob

"AdmiralAJ" wrote in message

...

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

Hi Bob,

Yes, I checked. I just looked under "manage rules" and the formatting
applies to that cell. But still not working.


AJ