Forum Discussion

Remco_van_Terheijden's avatar
Remco_van_Terheijden
Copper Contributor
Jul 15, 2020

Names of colors

If I make a custum cell and want to add: [Blauw]€ #.##0,00;[Rood]€ -#.##0,00 (blue and red)

What are the other options posible? I've found [Geel] (yellow) [Groen] (green) and [Wit] (white), but are there other names for colors to use and where can I find those? 

Or can you use RGB codes like (250,250,0) or #7F3939 or something?

excel

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jul 15, 2020

    Remco_van_Terheijden 

     

    Link from Subodh Tiwari sktneer everything is explained very well ... here is the table in German.

     

    Farben Tabelle

    You can also display the individual areas in different colors. To do this, type the color in front of the area formatting and put it in square brackets.
    To e.g. To format the positive area green and the negative area red, you could choose this custom number format:

    [GREEN] #. ## 0; [RED] - #. ## 0

     

    Nikolino

    I know I don't know anything (Socrates)