Forum Discussion
Solved
Assign color to specific numbers
Hello all, I`m a new member in this forum and this is my first post here. I use excel more and more in my day job and have discovered that excel is a very powerful tool with tons of functionality ...
Hi Niclas,
You can do that with another technique along with the Conditional Formatting.
After you finish the previous steps and apply the colors to the numbers:
- Select the range of numbers.
- Click Ctrl+1 to open the Format Cells dialog box.
- From the Number tab, select Custom category.
- In the Type box, type double quotation mark twice "" and then hit OK.
Hello Haytham,
First of all, thanks alot for your help.
An additional thing tho.
Is it possible to achieve that the numbers actually disappears in the actual cell? So only the color is visible?
Br
Niclas
Hi Niclas,
You can do that with another technique along with the Conditional Formatting.
After you finish the previous steps and apply the colors to the numbers:
- Select the range of numbers.
- Click Ctrl+1 to open the Format Cells dialog box.
- From the Number tab, select Custom category.
- In the Type box, type double quotation mark twice "" and then hit OK.
- Very good.
Thanks alot.
Works perfectly.