| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colors in cells depending on a value?
How to make Excel change the color in a cell if the cell's value is 1 ? Ex.
yellow I do not want anything to happen if the cell's value is empty. I use Office 2003. RR |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Colors in cells depending on a value?
Look up "Highlight cells that meet specific conditions" in help
"RR" wrote in message ... How to make Excel change the color in a cell if the cell's value is 1 ? Ex. yellow I do not want anything to happen if the cell's value is empty. I use Office 2003. RR |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Colors in cells depending on a value?
In the Main Menu,
Format = Conditional Formatting Cell value is equal to 1 set your color under the format button. -- Regards, Tom Ogilvy "RR" wrote in message ... How to make Excel change the color in a cell if the cell's value is 1 ? Ex. yellow I do not want anything to happen if the cell's value is empty. I use Office 2003. RR |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Colors in cells depending on a value?
Thanx a lot. :)
"RR" wrote: How to make Excel change the color in a cell if the cell's value is 1 ? Ex. yellow I do not want anything to happen if the cell's value is empty. I use Office 2003. RR |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add Cells in a row depending on Date | Excel Worksheet Functions | |||
| fixing pie chart colors depending upon value ? | Charts and Charting in Excel | |||
| Want to show/hide cells depending on other cells results | Excel Discussion (Misc queries) | |||
| Add numbers depending on other cells | Excel Worksheet Functions | |||
| How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
Linear Mode
