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


--
wborg
------------------------------------------------------------------------
wborg's Profile: http://www.excelforum.com/member.php...o&userid=29241
View this thread: http://www.excelforum.com/showthread...hreadid=489673

Hi W,

Try using the conditional format featu

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


---
Regards,
Norman


"wborg" wrote in
message ...

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


--
wborg
------------------------------------------------------------------------
wborg's Profile:
http://www.excelforum.com/member.php...o&userid=29241
View this thread: http://www.excelforum.com/showthread...hreadid=489673

Hi wborg,

Try

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

hope this helps,

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=489673