| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why did text in entered formula change to red in Spreadsheet
Why did text in entered formula change to red in Spreadsheet after I entered
a formula? Previos entries in column were in the usual black text. Thank you, TartanMaid |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why did text in entered formula change to red in Spreadsheet
Maybe that cell has Conditional Formatting applied?
Select that cell and FormatConditional Formatting. See if any conditions are set for that cell. Gord Dibben MS Excel MVP On Wed, 24 Jan 2007 19:19:01 -0800, TartanMaid wrote: Why did text in entered formula change to red in Spreadsheet after I entered a formula? Previos entries in column were in the usual black text. Thank you, TartanMaid |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why did text in entered formula change to red in Spreadsheet
....if not conditional formatting, then the number formatting could be the
culprit. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Maybe that cell has Conditional Formatting applied? Select that cell and FormatConditional Formatting. See if any conditions are set for that cell. Gord Dibben MS Excel MVP On Wed, 24 Jan 2007 19:19:01 -0800, TartanMaid wrote: Why did text in entered formula change to red in Spreadsheet after I entered a formula? Previos entries in column were in the usual black text. Thank you, TartanMaid |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| How do I change formula results by changing the text color of the | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| How do I change row text colors in Excel based on formula? | Excel Discussion (Misc queries) | |||
Linear Mode
