| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How do I make two lines in one cell? | Excel Discussion (Misc queries) | |||
| make a cell automatically populate with "1" when specified cell va | Excel Discussion (Misc queries) | |||
| can i type sheet1 A5 and make it show Sheet2 A6 cell | Excel Discussion (Misc queries) | |||
| Make a cell blank? | Excel Worksheet Functions | |||
Linear Mode
