Number format a cell based on the text in another cell [Closed]

Question

Number format a cell based on the text in another cell [Closed]

Report

nrus - Apr 27, 2016 at 07:28 AM
TrowaD

Posts: 2758
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 17, 2021

- 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
Conditional formatting in excel based on another cell - How-To - Excel
Conditional formatting: change fontcolor based on another cell ✓ - Forum - Excel
Format a cell with a comment based on a comment in another cell ✓ - Forum - Excel
Conditional formating is applied based on date in two cells ✓ - Forum - Excel
Format fill colour based on another cell ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2016-05-02T12:19:22-0400

Answer 1 / 1

TrowaD

Posts: 2758
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 17, 2021

462
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

Number format a cell based on the text in another cell [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!