| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for change background according to data
i have excel 2007
i want to set up a rule or a setting or something so that when a cell gets a set of numbers it will change the color of the cell to green example in the cell i want to add 5, 15, 25, 30 etc and any time a 5 or a 15 or a 25 or a 30 is typed into that cell it will chance the cell to green. is there any way of doing this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I universally change the background of a data label in grap | Charts and Charting in Excel | |||
| Auto change background of color based on formula | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| Change font and background color of several cells based on result of a formula | Excel Discussion (Misc queries) | |||
| Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
Threaded Mode
