Shade a cell on one wrksht if another wrksht cell is occupied

You can use Conditional Formatting, you just have to Name the cell you want it to refer to. Say in Sheet1!A1, you want to apply the shading if Sheet2!A1 = something. Go to Insert>Name>Define. Type in a name for the reference to Sheet!2A1 ( I used Shade). Go to the cell you want to apply the CF to. Change the Cell Value is: option to Formula is then use something like:

=Shade<>""

Click Format>Patterns and pick the color you want. Click OK and OK.

Does that help?

Steve

Thanks Steve,

I named the cell "GroupName" on the other worksheet. Can you tell me the
formula to achieve the following?

If the cell "GroupName" has ANY text in it, I want a separate worksheet cell
(call it A1) to fill in with a specific color. Does that make sense?

"SteveG" wrote:

>
> You can use Conditional Formatting, you just have to Name the cell you
> want it to refer to. Say in Sheet1!A1, you want to apply the shading
> if Sheet2!A1 = something. Go to Insert>Name>Define. Type in a name
> for the reference to Sheet!2A1 ( I used Shade). Go to the cell you
> want to apply the CF to. Change the Cell Value is: option to Formula
> is then use something like:
>
> =Shade<>""
>
> Click Format>Patterns and pick the color you want. Click OK and OK.
>
> Does that help?
>
> Steve
>
>
> --
> SteveG
> ------------------------------------------------------------------------
> SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
> View this thread: http://www.excelforum.com/showthread...hreadid=544350
>
>

In the Conditional Formatting dialog, change "Cell Value Is" to
"Formula Is", and enter the following formula:

=LEN(GroupName)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Clark" <Clark@discussions.microsoft.com> wrote in message
news:D208301B-AED4-4255-BB52-DAEE25FE10F5@microsoft.com...
> Thanks Steve,
>
> I named the cell "GroupName" on the other worksheet. Can you
> tell me the
> formula to achieve the following?
>
> If the cell "GroupName" has ANY text in it, I want a separate
> worksheet cell
> (call it A1) to fill in with a specific color. Does that make
> sense?
>
> "SteveG" wrote:
>
>>
>> You can use Conditional Formatting, you just have to Name the
>> cell you
>> want it to refer to. Say in Sheet1!A1, you want to apply the
>> shading
>> if Sheet2!A1 = something. Go to Insert>Name>Define. Type in
>> a name
>> for the reference to Sheet!2A1 ( I used Shade). Go to the
>> cell you
>> want to apply the CF to. Change the Cell Value is: option to
>> Formula
>> is then use something like:
>>
>> =Shade<>""
>>
>> Click Format>Patterns and pick the color you want. Click OK
>> and OK.
>>
>> Does that help?
>>
>> Steve
>>
>>
>> --
>> SteveG
>> ------------------------------------------------------------------------
>> SteveG's Profile:
>> http://www.excelforum.com/member.php...fo&userid=7571
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=544350
>>
>>

Clark,

See Chip's post.


Steve

Thanks guys, I got it to work!

"Chip Pearson" wrote:

> In the Conditional Formatting dialog, change "Cell Value Is" to
> "Formula Is", and enter the following formula:
>
> =LEN(GroupName)
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Clark" <Clark@discussions.microsoft.com> wrote in message
> news:D208301B-AED4-4255-BB52-DAEE25FE10F5@microsoft.com...
> > Thanks Steve,
> >
> > I named the cell "GroupName" on the other worksheet. Can you
> > tell me the
> > formula to achieve the following?
> >
> > If the cell "GroupName" has ANY text in it, I want a separate
> > worksheet cell
> > (call it A1) to fill in with a specific color. Does that make
> > sense?
> >
> > "SteveG" wrote:
> >
> >>
> >> You can use Conditional Formatting, you just have to Name the
> >> cell you
> >> want it to refer to. Say in Sheet1!A1, you want to apply the
> >> shading
> >> if Sheet2!A1 = something. Go to Insert>Name>Define. Type in
> >> a name
> >> for the reference to Sheet!2A1 ( I used Shade). Go to the
> >> cell you
> >> want to apply the CF to. Change the Cell Value is: option to
> >> Formula
> >> is then use something like:
> >>
> >> =Shade<>""
> >>
> >> Click Format>Patterns and pick the color you want. Click OK
> >> and OK.
> >>
> >> Does that help?
> >>
> >> Steve
> >>
> >>
> >> --
> >> SteveG
> >> ------------------------------------------------------------------------
> >> SteveG's Profile:
> >> http://www.excelforum.com/member.php...fo&userid=7571
> >> View this thread:
> >> http://www.excelforum.com/showthread...hreadid=544350
> >>
> >>
>
>
>

You're welcome.

Cheers,

Steve