| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is there a way to color the cells based on the numeric value?
How can I set up my worksheet so that the color of the cell will change based
on the value in that cell? For example, if the numeric value is 7, the color of the cell will be red. Any suggestions? |
|
#2
|
|||
|
|||
|
You can use CF
See http://www.contextures.com/xlCondFormat01.html -- Regards Ron de Bruin http://www.rondebruin.nl "ajyourpal" wrote in message ... How can I set up my worksheet so that the color of the cell will change based on the value in that cell? For example, if the numeric value is 7, the color of the cell will be red. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
| Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
| sum cells based on another cell value | Excel Worksheet Functions | |||
| how to color code a row of cells based on a specific cell value | New Users to Excel | |||
| Put an autoshape in a cell based on another cells content | Excel Worksheet Functions | |||
Linear Mode
