How can I make a cell a certain color dependent on number value?
I am wondering if it is possible to come up with a formula that colors cells
dependent on the numerical value. (ie If a=30 color will be blue, if a=40 color will be red, etc.) Thanks |
Hi Sue,
You can do this with conditional formatting under format. Pat "Sue" wrote: I am wondering if it is possible to come up with a formula that colors cells dependent on the numerical value. (ie If a=30 color will be blue, if a=40 color will be red, etc.) Thanks |
All times are GMT +1. The time now is 01:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com