Number format a cell based on the text in another cell

Closed

nrus - Apr 27, 2016 at 07:28 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - May 2, 2016 at 12:19 PM

Hello,

I want to conditionally format a cell to change the number formatting to a percentage or currency based on the text in another cell.

For example, if cell A says 'CPM', I want the value in cell B to become a currency (£). But if cell A says 'CTR', I want the value in cell B to become a percentage.

thanks,

Number format a cell based on the text in another cell
Clear only the formatting from the selected cell (leaving the content) - Guide
Count if cell contains number - Excel Forum
Which example represents cell data with the date format applied to it? - Excel Forum
Format factory - Download - Other
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
May 2, 2016 at 12:19 PM

Hi Nrus,

Select the range of cells in column B. Go to conditional formatting and apply new custom rule: =$A2="CPM" and apply currency format.

Do the same for 'CTR'.

When done correctly hitting OK to close CF should change the range of cells in column B accordingly.

Best regards,
Trowa

Similar discussions

help me to add particular cells

Fill adjacent cell with number from text answer

Highlight cell if another cell contains specific text

Excel function question

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!