Cell Format based on conditional formatting [Closed]

Report
-
Posts
2755
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 3, 2021
-
Hello,

Can anyone help me figure out if excel 2010 allows for cell formatting based on text? I have two columns, and in Col A, I have text that reads "$ AMT" or "% PCT". If $ AMT is selected in cell A1, then I need cell B1 to change format for currency. If % PCT is selected in cell A2, then I need cell B2 to format to %.

Does anyone know if Excel can do this?

1 reply

Posts
2755
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 3, 2021
462
Hi Pat-t,

Excel can do this!

Select column B > conditional formatting > add 2 formula's:
=$A2="$ AMT" > apply Currency format from number tab
=$A2="% PCT" > apply Percentage format from number tab

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!