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