| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
dynamically changing text color
Is there a way to have the text/font color change in a cell depending on the
value entered? For example: starting with cell A1, if I enter a value in cell A2 and it is a lower number than A1 can it dynamically change to red text? Or if the value in A2 is greater than A1 can it dynamically change to green text? What I am trying to accomplish is enter multiple values in a column and just enter the number in each cell, A1, A2, A3... and depending on the value comparison to the cell above, change the color of the cell contents. Is that possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dynamically changing text color
What version of Excel do you have?
This is for versions prior to Excel 2007. Assume you want to apply this to the range of cells from A2:A10 Select the range A2:A10 Goto the menu FormatConditional Formatting Condition 1 Formula Is: =AND(COUNT(A1:A2)=2,A2<A1) Click the Format button Set the font color to RED OK Click the ADD button Condition 2 Formula Is: =AND(COUNT(A1:A2)=2,A2A1) Click the Format button Set the font color to GREEN OK out This assumes that you intend to enter values in the cells in sequence. Like: A1, A2, A3, A4, A5 etc Not like: A1, A2, A5, A10 If intend to go out of sequence we'll need different formulas. Biff "Dave" wrote in message ... Is there a way to have the text/font color change in a cell depending on the value entered? For example: starting with cell A1, if I enter a value in cell A2 and it is a lower number than A1 can it dynamically change to red text? Or if the value in A2 is greater than A1 can it dynamically change to green text? What I am trying to accomplish is enter multiple values in a column and just enter the number in each cell, A1, A2, A3... and depending on the value comparison to the cell above, change the color of the cell contents. Is that possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dynamically changing text color
Thanks Biff, works perfectly. I have the workbook saved for Excel 2003 and
2007. Are there different rules on 2007? D "T. Valko" wrote: What version of Excel do you have? This is for versions prior to Excel 2007. Assume you want to apply this to the range of cells from A2:A10 Select the range A2:A10 Goto the menu FormatConditional Formatting Condition 1 Formula Is: =AND(COUNT(A1:A2)=2,A2<A1) Click the Format button Set the font color to RED OK Click the ADD button Condition 2 Formula Is: =AND(COUNT(A1:A2)=2,A2A1) Click the Format button Set the font color to GREEN OK out This assumes that you intend to enter values in the cells in sequence. Like: A1, A2, A3, A4, A5 etc Not like: A1, A2, A5, A10 If intend to go out of sequence we'll need different formulas. Biff "Dave" wrote in message ... Is there a way to have the text/font color change in a cell depending on the value entered? For example: starting with cell A1, if I enter a value in cell A2 and it is a lower number than A1 can it dynamically change to red text? Or if the value in A2 is greater than A1 can it dynamically change to green text? What I am trying to accomplish is enter multiple values in a column and just enter the number in each cell, A1, A2, A3... and depending on the value comparison to the cell above, change the color of the cell contents. Is that possible? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dynamically changing text color
Are there different rules on 2007?
The same formulas will work. I don't have Excel 2007 so I don't know how to actually get to the conditional formatting menus (ribbon in Excel 2007). So, in my reply I say go here, select this, do that, but these steps may not apply in Excel 2007. Biff "Dave" wrote in message ... Thanks Biff, works perfectly. I have the workbook saved for Excel 2003 and 2007. Are there different rules on 2007? D "T. Valko" wrote: What version of Excel do you have? This is for versions prior to Excel 2007. Assume you want to apply this to the range of cells from A2:A10 Select the range A2:A10 Goto the menu FormatConditional Formatting Condition 1 Formula Is: =AND(COUNT(A1:A2)=2,A2<A1) Click the Format button Set the font color to RED OK Click the ADD button Condition 2 Formula Is: =AND(COUNT(A1:A2)=2,A2A1) Click the Format button Set the font color to GREEN OK out This assumes that you intend to enter values in the cells in sequence. Like: A1, A2, A3, A4, A5 etc Not like: A1, A2, A5, A10 If intend to go out of sequence we'll need different formulas. Biff "Dave" wrote in message ... Is there a way to have the text/font color change in a cell depending on the value entered? For example: starting with cell A1, if I enter a value in cell A2 and it is a lower number than A1 can it dynamically change to red text? Or if the value in A2 is greater than A1 can it dynamically change to green text? What I am trying to accomplish is enter multiple values in a column and just enter the number in each cell, A1, A2, A3... and depending on the value comparison to the cell above, change the color of the cell contents. Is that possible? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
dynamically changing text color
It is actually quite different although you can eventually get to a similar
dialogue box as in earlier versions. As usual it takes much longer to get the same thing done. -- Regards, Peo Sjoblom "T. Valko" wrote in message ... Are there different rules on 2007? The same formulas will work. I don't have Excel 2007 so I don't know how to actually get to the conditional formatting menus (ribbon in Excel 2007). So, in my reply I say go here, select this, do that, but these steps may not apply in Excel 2007. Biff "Dave" wrote in message ... Thanks Biff, works perfectly. I have the workbook saved for Excel 2003 and 2007. Are there different rules on 2007? D "T. Valko" wrote: What version of Excel do you have? This is for versions prior to Excel 2007. Assume you want to apply this to the range of cells from A2:A10 Select the range A2:A10 Goto the menu FormatConditional Formatting Condition 1 Formula Is: =AND(COUNT(A1:A2)=2,A2<A1) Click the Format button Set the font color to RED OK Click the ADD button Condition 2 Formula Is: =AND(COUNT(A1:A2)=2,A2A1) Click the Format button Set the font color to GREEN OK out This assumes that you intend to enter values in the cells in sequence. Like: A1, A2, A3, A4, A5 etc Not like: A1, A2, A5, A10 If intend to go out of sequence we'll need different formulas. Biff "Dave" wrote in message ... Is there a way to have the text/font color change in a cell depending on the value entered? For example: starting with cell A1, if I enter a value in cell A2 and it is a lower number than A1 can it dynamically change to red text? Or if the value in A2 is greater than A1 can it dynamically change to green text? What I am trying to accomplish is enter multiple values in a column and just enter the number in each cell, A1, A2, A3... and depending on the value comparison to the cell above, change the color of the cell contents. Is that possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing several cells text color | Excel Discussion (Misc queries) | |||
| Changing text color within a formula??? | Excel Discussion (Misc queries) | |||
| How to do if then statements changing color text? | Excel Discussion (Misc queries) | |||
| Dynamically changing Border-Color of all series() to "0" | Charts and Charting in Excel | |||
| changing font color for new text | Excel Discussion (Misc queries) | |||
Hybrid Mode
