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