| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 cell result changes color
Is there anyway to have a result of a formula change the color of that cell?
Is there a way to compare two cells, then allow one of the cells to change color if the differance is positive or negative?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 cell result changes color
Use Conditional Formatting
formula is see: http://www.contextures.com/xlCondFormat01.html -- Gary's Student gsnu200705 "billz" wrote: Is there anyway to have a result of a formula change the color of that cell? Is there a way to compare two cells, then allow one of the cells to change color if the differance is positive or negative?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 cell result changes color
The site you included did the trick. Thanks.
"Gary''s Student" wrote: Use Conditional Formatting formula is see: http://www.contextures.com/xlCondFormat01.html -- Gary's Student gsnu200705 "billz" wrote: Is there anyway to have a result of a formula change the color of that cell? Is there a way to compare two cells, then allow one of the cells to change color if the differance is positive or negative?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003 cell result changes color
For first part.............select the cell to color
FormatCondtional Formatting Cell value is: whatever Format to a pattern For second part.........select A1 as an example FormatCFCondition1Formula is: =A1B1 Format to a pattern Condition2Formula is: =A1<B1 Format to a pattern You may also want to look at Absolute and Relative cell referencing using $ signs. Gord Dibben MS Excel MVP On Tue, 13 Feb 2007 16:51:03 -0800, billz wrote: Is there anyway to have a result of a formula change the color of that cell? Is there a way to compare two cells, then allow one of the cells to change color if the differance is positive or negative?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Result of IF conditional change cell color | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| Can an IF formula result in a color filled cell in Excel? | Excel Worksheet Functions | |||
| In Microsoft Excel 2003, when I select a color for a cell it does. | Excel Worksheet Functions | |||
Hybrid Mode
