getting the same colour

[Malcolm Dew-Jones]

Hello

I want a cell to automatically take on the same colour as the cell above
when I write something into it.

This happens _some_ of the time for me, but not all the time. I have no
idea what would control this.

FOr example, What I do is this... The cell starts out as white. The cell
above it is yellow. Then I type something into the (white) cell and press
[Enter]. The white cell _sometimes_ changes colour to be yellow, (and
then the next lower cell becomes the current cell for my typing).

The colour change happens more consistently in the cells in the higher
numbered rows. The column doesn't seem to make a difference.

I can't see anything different about any cells formats, and there
shouldn't be anyways, since the spread sheet has nothing fancy in it, it's
just a list of entries that I mark off to keep track of some repetitive
tasks.


Could anyone explain to me what could control the automatic colouring of
each cell as you type into it?

Thanks for any feedback.

 

[Guest]

It sounds like the sheet may have Conditional Formatting applied to it.
Check Format | Conditional Formatting to see if there is anything chosen.
You may need to select a cell that is having this happen to see for sure.

If that comes up empty ...
Do you have any Add-Ins that you are aware of? Some third party additions to
Excel do things like change Font or Cell Color when something is entered into
a cell.
Check the Menus for any commands that seem to deal with color.

tj

 

[JE McGimpsey]

Make sure you have the Tools/Options/Edit/Extend list formats and
formulas checkbox checked.

From XL Help ("Turn on or off extended formats and formulas")

When you turn on extended formats and formulas, Microsoft Excel automatically
formats new data that you type at the end of a list to match the preceding
cells and automatically copies formulas that repeat in every row or column.
To be extended, formats and formulas must appear in at least three of the
five list cells preceding the new cell.

Hello

I want a cell to automatically take on the same colour as the cell above
when I write something into it.

This happens _some_ of the time for me, but not all the time. I have no
idea what would control this.

FOr example, What I do is this... The cell starts out as white. The cell
above it is yellow. Then I type something into the (white) cell and press
[Enter]. The white cell _sometimes_ changes colour to be yellow, (and
then the next lower cell becomes the current cell for my typing).

The colour change happens more consistently in the cells in the higher
numbered rows. The column doesn't seem to make a difference.

I can't see anything different about any cells formats, and there
shouldn't be anyways, since the spread sheet has nothing fancy in it, it's
just a list of entries that I mark off to keep track of some repetitive
tasks.


Could anyone explain to me what could control the automatic colouring of
each cell as you type into it?

Thanks for any feedback.

 

[Malcolm Dew-Jones]

=?Utf-8?B?dGp0amp0anQ=?= ([email protected]) wrote:
: It sounds like the sheet may have Conditional Formatting applied to it.
: Check Format | Conditional Formatting to see if there is anything
chosen.
: You may need to select a cell that is having this happen to see for
sure.

Nope, can't find anything like that defined for any cells.

: If that comes up empty ...
: Do you have any Add-Ins that you are aware of? Some third party
additions to
: Excel do things like change Font or Cell Color when something is entered
into
: a cell.

An idea I will check into, though I don't think there is anything like
that. The PCs here are pretty generic.


JE McGimpsey ([email protected]) wrote:
: Make sure you have the Tools/Options/Edit/Extend list formats and
: formulas checkbox checked.

I have now checked and it was and remains selected. However I will
investigate this option further, cause it sounds like the sort of "second
guessing" that is going on (except that it doesn't do what I want most of
the time).

: From XL Help ("Turn on or off extended formats and formulas")

: > When you turn on extended formats and formulas, Microsoft Excel automatically
: > formats new data that you type at the end of a list to match the preceding
: > cells and automatically copies formulas that repeat in every row or column.
: > To be extended, formats and formulas must appear in at least three of the
: > five list cells preceding the new cell.

So, no joy so far, but thanks for the feedback.