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

[keithl816]

Hi wborg,

Try

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

hope this helps,

Larry

[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


---
Regards,
Norman


"wborg" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>