Cell colours and font colours

[Casperion]

I seem to remember that when you changed the cell to a very dark colour, the
font automatically changed from black to white. My font setting is
automatic colour but when I change the cell from no colour to black the cell
contents do not display until I go and format the font to white from
automatic. Is there something I need to set up elsewhere to make the font
change colour automatically depending on my background colour?

Thanks - Roger

 

[Dave Peterson]

I don't recall ever seeing this behavior.

And it's a pretty common way to "hide" contents of cells. Just make the fill
color the same as the font color.

 

[Casperion]

Dave - thanks but I am not trying to hide the contents of the cell, but more
to contrast them. The font colour should change when it is in the
'automatic' setting to contrast against the cell colour. So, black or dark
coloured cell, content should turn white. White or light coloured cell the
font colour should automatically turn black. Is that not so?

Roger

"Dave Peterson"

 

[Dave Peterson]

I don't think so. I was trying to show that lots of people would hide the
contents of cells using this technique. So I would find it difficult to believe
that it would be a common request (or a current behavior).

Dave - thanks but I am not trying to hide the contents of the cell, but more
to contrast them. The font colour should change when it is in the
'automatic' setting to contrast against the cell colour. So, black or dark
coloured cell, content should turn white. White or light coloured cell the
font colour should automatically turn black. Is that not so?

Roger

"Dave Peterson"

 

[Casperion]

Thanks - I don't, then, understand what 'automatic' font colour is supposed
to achieve. When I believe the function did work, the font colour was
defaulted to automatic - clearly if you want to hide cell content colour you
would have to do so by selecting the same colour for cell and content but my
default allowed the font to contrast against its background. Can't find
anything in MS Office Workbook either so, even though I know I am not
dreaming, I must have been!! Thanks for your thoughts - Roger

I don't think so. I was trying to show that lots of people would hide the
contents of cells using this technique. So I would find it difficult to
believe
that it would be a common request (or a current behavior).

 

[Debra Dalgleish]

The font colour on sheet tabs automatically changes if you select a dark
tab colour. Maybe that's what you're remembering.

Thanks - I don't, then, understand what 'automatic' font colour is supposed
to achieve. When I believe the function did work, the font colour was
defaulted to automatic - clearly if you want to hide cell content colour you
would have to do so by selecting the same colour for cell and content but my
default allowed the font to contrast against its background. Can't find
anything in MS Office Workbook either so, even though I know I am not
dreaming, I must have been!! Thanks for your thoughts - Roger

 

[Casperion]

Thanks Debra - I checked to see and it does change the font colour in the
sheet tab with a dark tab colour selected. Since I never used that facility
it can't be that - but that is the effect that I am trying to describe - but
in cells. So I best give up!! Thanks all for your checking this out -
Roger

The font colour on sheet tabs automatically changes if you select a dark
tab colour. Maybe that's what you're remembering.

 

[Microsoft]

Casperion

You're not confusing the behaviour you suggest with what happens to tables
in Word, are you? The font colour in those will change to white if you
select a black background.

Or possibly with Excel's default behaviour when you select a number of cells
and the font colour in the darkened cells changes to white while the cells
remain selected?

Drew

 

[Drew Paterson]

Microsoft indeed!!! I should be so lucky!!!

That's what happens when you have to re-load everything from scratch!

Drew