Skybluekid
Well-known Member
- Joined
- Apr 17, 2012
- Messages
- 1,231
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a cell that contains a number. What I would like to do is prefix this, using Conditional Formatting(?), so that when a value changes the format of the cell will change.
Eg. If D4 has a number of 1700. If program 1 is selected in F4, then in D4 the format will show XXX 1700. If program 2 is selected in F4, D4 will format as XXXX 1700.
The formats I would like you are currently a Custom Format, that I have created.
Thanks in Advance
I have a cell that contains a number. What I would like to do is prefix this, using Conditional Formatting(?), so that when a value changes the format of the cell will change.
Eg. If D4 has a number of 1700. If program 1 is selected in F4, then in D4 the format will show XXX 1700. If program 2 is selected in F4, D4 will format as XXXX 1700.
The formats I would like you are currently a Custom Format, that I have created.
Thanks in Advance