Posted by: Gomzy | December 29, 2006

Color Codes in MS Excel

If you want to apply some color in your Excel Sheet through the UDF, then use the following Color codes:

SL No. Color Color Code
1 White 2
2 Lavender 39
3 Pale Blue 37
4 Light Turquoise 34
5 Light Green 35
6 Light Yellow 36
7 Tan 40
8 Rose 38
9 Grey 25% 15
10 Plum 54
11 Sky Blue 33
12 Turquoise 8
13 Bright Green 4
14 Yellow 6
15 Gold 44
16 Pink 7
17 Grey 40% 48
18 Voilet 13
19 Light Blue 41
20 Aqua 42
21 Sea Green 50
22 Lime 43
23 Light Orange 45
24 Red 3
25 Grey 50% 16
26 Blue-Grey 47
27 Blue 5
28 Teal 14
29 Green 10
30 Dark Yellow 12
31 Orange 46
32 Dark Red 9
33 Grey 80% 56
34 Indigo 55
35 Dark Blue 11
36 Dark Teal 49
37 Dark Green 51
38 Olive Green 52
39 Brown 53
40 Black 1


  1. Good day sir,

    I have an excel spread sheet with rows and coloums with different “cell colours” (Red, Blue, Green & yellow. We are given different color codes for identifying unique type of vehicles we pass through. Is there is any option/ formula to count the cell’s with unique colour?, like howmany red, howmany green like that? please help me out , if you have a solution.

    Thanking You,

  2. excellent points altogether, you simply received a brand new reader.

    What might you suggest in regards to your publish that you just made some days in the past?
    Any sure?

  3. I do not know whether it’s just me or if perhaps everybody else
    experiencing issues with your blog. It appears as though some of the text on your posts are
    running off the screen. Can someone else please comment and let me know if this
    is happening to them too? This could be a problem with my internet browser because I’ve had this happen previously.
    Many thanks

  4. Unquestionably believe that which you stated.

    Your favorite justification appeared to be on the internet the simplest thing to be aware of.
    I say to you, I certainly get annoyed while people consider worries
    that they just do not know about. You managed to hit the nail
    upon the top and also defined out the whole thing without having side-effects , people could
    take a signal. Will probably be back to get more.

  5. If you wish for to improve your experience only keep
    visiting this web site and be updated with the most up-to-date news postdd here.

  6. I just couldn’t leave your website before suggesting that I actually
    loved the standard information a person provide to your visitors?
    Is gonna be again frequently in order to check out new posts

  7. The doctors of Dermatology Associates in Tinley Park, Illinois, include Aveeno Clear Complexion Foaming Cleanser, Cleansing Pads, Positively Radiant
    Moisturizer and Ultra-Calming Moisturizer among the products they recommend
    for their patients with acne-prone skin. Water gets everywhere, including
    all over the place.

  8. Write more, thats all I have to say. Literally, it seems as though you relied on the video to
    make your point. You clearly know what youre talking about, why throw
    away your intelligence on just posting videos to your weblog when you could be giving us something informative to read?

  9. These celebrity hairstyles are cut and styled.
    You can ask your hairdresser to show you to type your hair.
    No, of course with black hairstyles celebrities boosting its popularity, the sedu hair iron can help to achieve a better result.
    Of course, black hairstyles you would surely need an expert
    hairstylist for the professional touch.

  10. Hey there! This is my first visit to your blog!
    We are a group of volunteers and starting a new
    project in a community in the same niche. Your blog
    provided us useful information to work on. You have done a wonderful job!

  11. Excellent blog you’ve got here.. It’s difficult to find quality writing like yours nowadays.
    I seriously appreciate people like you! Take care!!

  12. We will begin to develop x-rays, dental fillings alone cannot effectively
    solve the problem. Dental insurance provides a convenient life.
    Every individual disease, strokes, up until the child enters preschool.

    Severe damageThere can be affected. But not everyone is doing to your teeth bleaching is a
    new appointment?

  13. I see you don’t use the potential of social websites like FB
    on your site. You can get big traffic from social sites
    on autopilot using one useful tool, for more info search in google
    Alufi’s Social Automation

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: