Forum Discussion

Brass Contributor

Apr 07, 2018

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 ...

Colors.xlsx10 KB

Assign specific color to custom numbers

Haytham Amairah
Apr 07, 2018
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.

Haytham Amairah

Silver Contributor

Apr 07, 2018

Hi Niclas,

Welcome to Microsoft Excel Community!

There is a powerful tool in Excel called (Conditional Formatting), through this tool you can achieve what you asking for in the following steps:

Select the range (for example A1:B5) that you want to assign the colors to it.
Go to Home >> Styles >> Conditional Formatting >> Highlight Cells Rules >> Equal To.
In Equal To dialog box put the number and assign the color that you want to it, then click OK.
Do the same steps for each number.

I hope this helps you