Conditionally Format Numbers based on Text in another Cell

[RLBrown]

Hello Mr. Excel Members, I'm hoping someone can help me format numbers based on text. Scenario:
Cell A1 contains 5 unique names in 'text'. (Price, ACV, Units, etc.)

If A1 contains the word 'Price' I want the number in B1 to be formatted as currency ($00.00)
If A1 contains the word 'Units' I want the number in B1 to be formatted as number (000)
If A1 contains the word 'ACV' I want the number in B1 to be formatted as Percent (00.0%)

I can't figure out how to tie the specific word and number format together so that the formats automatically change based on what is in A1.

Any help appreciated! Rhonda

 

[DanteAmor]

Follow the steps:

1.Menu Formatting conditional, new rule, Use a formula to determine which cells to format.

2. Format values where this formla is true:
=$A$1="Price"

3. Press button "Format"

4. On tab Number select Currency

5. Press Ok, Press Ok

6. In Apples To:
=$B$1

7. OK

Repeat the steps for the other formats