Certain cells turn red & no formatting is applied

[Lib]

I'm using Excel 2002 & have copied from a 1-2-3 doc. In
certain parts of the front sheet only, the background
turns to red, whenever I enter anything. No formatting
has been applied and it doesn't seem to be protected. I
can turn it back to white manually, but it changes again
the next time. How can I stop this from happening?

Thanks for your help!

 

[Frank Kabel]

Hi
one idea: check conditional formating (goto 'Format - Conditional
format')

 

[Lib]

I have checked conditional formatting and there is none.
Other spreadsheets I have converted from 1-2-3 are fine.

Thanks,

 

[Norman Harker]

Hi Lib!

Right Click on the sheet tab and see if there is any code. I suspect a
Worksheet_Change event handling subroutine.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
another idea: There may be some event code behind this sheet. check the
following:
- right click on the tab name and choose 'code' from the context menu
- check if there's some code in the appearing editor window (e.g. sub
worksheedt_change(...))
- if yes you may delete this code, close the editor and try again

If this all does not help you may email me your file and I'll have a
look at it

 

[Lib]

That WAS the problem in a way, but I've found a way to
circumvent it. There is code further down the page that
has a Case Else:
.Interior.ColorIndex = 3 'Red
Above the cells that this code points to, it turns red,
below the cells it was fine. I've discovered a way,
though to use conditional formatting to do the same
thing.

Thank you so much for your help!! You're a lifesaver.