Change backgroundcolor

[wborg]

Hi,

I've searched the forums and didn't find what I'm looking for so I ask
it myself.

I wonder if there is any way to change the backgroundcolor depending on
if there is any text or not in the specific cell.

Exampel:

I have a couple of editable cells that are 25% Grey to indicate for the
user that this cell is where you should type in a name for exampel. When
the user types in a name into that cell I want it to change to white
background.

Is this possible and if so how to achieve that?

/wborg

 

[Norman Jones]

Hi W,

Try using the conditional format feature:

Format | Conditiona Formatting ...

If you are not familiar with this feature, see Debra Dalgleish's tutorial on
Conditional formatting at:

http://www.contextures.com/xlCondFormat01.html

 

[keithl816]

Hi wborg,

Try

Format/Conditional Formatting/Pick your condition/Format/Patterns/Pic
your color

hope this helps,

Larr