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 |
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 |
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 |
All times are GMT +1. The time now is 06:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com