lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
When I do this custom format [color12]#;[color13]#
How can I list all the color code in the sheet so I can see which code give me this color or that. Is there any function or formula to transfer the number to name of the color
for example
1 black
2 white
3 red
I can do google it but was wondering if excel can give me that list as well. Thank you very much.
When I do this custom format [color12]#;[color13]#
How can I list all the color code in the sheet so I can see which code give me this color or that. Is there any function or formula to transfer the number to name of the color
for example
1 black
2 white
3 red
I can do google it but was wondering if excel can give me that list as well. Thank you very much.