How to change the cell color in excel

Asked By Jesica Minnie 40 points N/A Posted on - 08/01/2012

I want to change the background color of the cell according to the value.

I have an itemized list and value which are issued to main stores to branches.

There are different amounts of item value. I want to change the color of each cell according to the value based on the following conditions.

 

Less than 25,000.00                                         Yellow

Between 25,000.00 and 50,000 Red

More than 50,000.00                                      Green

How can I do this?

• Status: Open
• Question Views: 1122
• Answer Count: 2
• Vote Up 1 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Geisha Nitta

Go To Solution

Best Answer

Best Answer

Answered By Geisha Nitta 0 points N/A #134584

How to change the cell color in excel

Your requirement can be easily done using the conditional formatting which is available in Microsoft excel. Let see how it happened. I will take an example in order to explain this. Please try to understand it carefully.

As you mentioned in your question I took some data.

Now select the entire column B and click on the conditional formatting in the styles section.

Then select the highlight cell rules and click on the between.

In the next window, type “0” to first white box and “25000” to next white box.

Then Select “Yellow fill with dark Yellow Text”, from the “with” drop down list and click ok.

Again follow the same steps and type 25000 in the first white box and 50000 in the next white box.

Then Select “Light Red fill with dark Red Text”, from the “with” drop down list and click ok.

Again do the same thing and take values as 50000 and 1000000.Select “Green fill with dark Green Text”.

Now your answer is complete.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/01/2012
• Question Category: MS Excel

Answered By Fosso pradha 0 points N/A #134585

How to change the cell color in excel

Dear User,

Changing cell colors in excel is very easy.

First right click the particular cell, and select Format cells from the drop down menu.

When the format window opens select fill tab,

There you can select the color you want to apply and then click ok.

Thank you.

About Fosso pradha

Questions
1

Answers
247

Best Answers
85

• Vote Up 0 Vote Down

• Posted on - 08/06/2012
• Question Category: MS Excel