How do I stop the font from changing colour automatically?
 

If I change the font colour in a cell, sometimes the text I type in the cell
beneath it changes automatically to the same colour. How do I stop this?
(This also happens with fill colours)

How do I stop the font from changing colour automatically?
 

Tools Options... Edit clear the extend range formats checkbox
--
Gary''s Student - gsnu200750