Thread: Why did text in entered formula change to red in Spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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

Reply With QuoteReply With Quote