|If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.|
||Thread Tools||Display Modes|
getting the same colour
=?Utf-8?B?dGp0amp0anQ=?= ) wrote:
: It sounds like the sheet may have Conditional Formatting applied to it.
: Check Format | Conditional Formatting to see if there is anything
: You may need to select a cell that is having this happen to see for
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
: Excel do things like change Font or Cell Color when something is entered
: 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 ) 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
: 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.
|Thread||Thread Starter||Forum||Replies||Last Post|
|how 'come green isn't green?||ericx||Excel Discussion (Misc queries)||7||November 26th 04 02:49 PM|