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
> >>
> >>
>
>
>