Previous Topic Next Topic

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

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

14 responses