ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I am trying to color fill a cell based on specific criteria (https://www.excelbanter.com/excel-discussion-misc-queries/28141-i-am-trying-color-fill-cell-based-specific-criteria.html)

jglen

I am trying to color fill a cell based on specific criteria
 
If a cell value is 1-5, fill the cell with red color; if cell value = 5-9,
fill the cell with yellow; etc.

Dan

Go to the format menu, and click on conditional formating. Enter your
criteria and select your formatting... It is fairly straight forward, post
if you still have problems.

Dan

"jglen" wrote:

If a cell value is 1-5, fill the cell with red color; if cell value = 5-9,
fill the cell with yellow; etc.



All times are GMT +1. The time now is 03:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com