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
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Format factory - Download - Other

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

Highlight cell if another cell contains specific text

Excel function question

If a cell contains any text then add a value

Fill adjacent cell with number from text answer

Similar discussions

Subscribe To Our Newsletter!