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 Contributor Last seen December 27, 2022 - May 2, 2016 at 12:19 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - May 2, 2016 at 12:19 PM
Related:
- Number format a cell based on the text in another cell
- If a cell has text then return value ✓ - Excel Forum
- Based on the values in cells b77 b88 - Excel Forum
- Insert a function in cell b2 to display the current date from your system. ✓ - Excel Forum
- How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum
- Count if cell contains number - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
May 2, 2016 at 12:19 PM
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
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