How to change the cell color in excel

Asked By 40 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Geisha Nitta
Best Answer
Best Answer
Answered By 0 points N/A #134584

How to change the cell color in excel

qa-featured

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.

Conditional Formating

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.

Conditional formating Hightlight Cell rule

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.

Format the cells Between

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.

Color the Format cells

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

MS Excel Conditional Formating

Now your answer is complete.

Conditional Formating
Answered By 0 points N/A #134585

How to change the cell color in excel

qa-featured

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.

Cell Color Configuration

When the format window opens select fill tab,

Format Cell

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

Thank you.

Login/Register to Answer

Related Questions