Cell Format based on conditional formatting

Closed
Pat-t - Jun 9, 2016 at 07:33 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 13, 2016 at 11:05 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 13, 2016 at 11:05 AM
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
0