I have a spreadsheet (xls) that whenever I enter a value into a cell
the text is in red and the background is turning a bright yellow
regardless of what the font & background settings are. What is
causing this?

Help please... Bob

Possibly Conditional Formatting is the cause.
Select the cell, then from the Format menu,
choose Conditional Formatting and see what is displayed in the box that pops up.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(excel add-ins and workbooks)

..
..
..

"Bob" <(E-Mail Removed)>
wrote in message
news:0e3168cd-7fc5-4099-ae0a-(E-Mail Removed)...
I have a spreadsheet (xls) that whenever I enter a value into a cell
the text is in red and the background is turning a bright yellow
regardless of what the font & background settings are. What is
causing this?

Help please... Bob

And if it's not conditional formatting, look for a macro that's running when you
make a change to a cell.

Try this:
Close excel
Reopen excel in safe mode
Windows start button|Run
type:
Excel /safe

The use File|Open to open your workbook and test.

On 10/08/2010 20:15, Bob wrote:
> I have a spreadsheet (xls) that whenever I enter a value into a cell
> the text is in red and the background is turning a bright yellow
> regardless of what the font& background settings are. What is
> causing this?
>
> Help please... Bob

--
Dave Peterson

In my case (Excel 2010), the fix was:
File -> Options -> Advanced -> Uncheck "Extend data range format and
formulas"

Solution found here:
http://www.mrexcel.com/forum/showthread.php?t=74324

On 9 oct, 13:18, Dave Peterson <peter...@XSPAMverizon.net> wrote:
> And if it's not conditional formatting, look for a macro that's running when you
> make a change to a cell.
>
> Try this:
> Close excel
> Reopen excel in safe mode
> Windows start button|Run
> type:
> Excel /safe
>
> The use File|Open to open your workbook and test.
>
> On 10/08/2010 20:15, Bob wrote:
>
> > I have a spreadsheet (xls) that whenever I enter a value into a cell
> > the text is in red and the background is turning a bright yellow
> > regardless of what the font& *background settings are. *What is
> > causing this?
>
> > Help please... Bob
>
> --
> Dave Peterson