Can I automatically shade a range of cells when certain text is typed into a
specific cell?

You can set those cells up with conditional formatting, with a formula of
say =$A$1="abc" and set the pattern colour.

--

HTH

RP

"Jim Johnson" <(E-Mail Removed)> wrote in message
news:A95629B8-281E-44CA-972B-(E-Mail Removed)...
> Can I automatically shade a range of cells when certain text is typed into
a
> specific cell?

Hi Bob,

Can you give me an example of the formula if I wanted to shade cells A1 to
H1 depending on the text in cell G1? Also, how do you set the pattern fill?
Will it simply fill with the default color? If so, how do you change the
default color?

Thanks,
Jim

"Bob Phillips" wrote:

> You can set those cells up with conditional formatting, with a formula of
> say =$A$1="abc" and set the pattern colour.
>
> --
>
> HTH
>
> RP
>
> "Jim Johnson" <(E-Mail Removed)> wrote in message
> news:A95629B8-281E-44CA-972B-(E-Mail Removed)...
> > Can I automatically shade a range of cells when certain text is typed into
> a
> > specific cell?
>
>
>

Hi
- select A1:H1
- goto 'Format - Conditional Format'
- enter the following formula in this dialog:
=$G1="your text"
- click on 'Format' and choose your fill color for this condition

--
Regards
Frank Kabel
Frankfurt, Germany

"Jim Johnson" <(E-Mail Removed)> schrieb im
Newsbeitrag news:FB2086D7-D757-4BB3-8D83-(E-Mail Removed)...
> Hi Bob,
>
> Can you give me an example of the formula if I wanted to shade cells
A1 to
> H1 depending on the text in cell G1? Also, how do you set the
pattern fill?
> Will it simply fill with the default color? If so, how do you change
the
> default color?
>
> Thanks,
> Jim
>
> "Bob Phillips" wrote:
>
> > You can set those cells up with conditional formatting, with a
formula of
> > say =$A$1="abc" and set the pattern colour.
> >
> > --
> >
> > HTH
> >
> > RP
> >
> > "Jim Johnson" <(E-Mail Removed)> wrote in
message
> > news:A95629B8-281E-44CA-972B-(E-Mail Removed)...
> > > Can I automatically shade a range of cells when certain text is
typed into
> > a
> > > specific cell?
> >
> >
> >

select A1:H1. Then Format/Conditional formatting. In the first box, select
Formula Is. In the box to the right type =$G1="the text you want"

Note the dollar sign in front of the G. That's critical.

Then click on the Format button. There are tabs for font, border, and
patterns. Make the settings you want.

On Thu, 28 Oct 2004 22:10:05 -0700, "Jim Johnson"
<(E-Mail Removed)> wrote:

>Hi Bob,
>
>Can you give me an example of the formula if I wanted to shade cells A1 to
>H1 depending on the text in cell G1? Also, how do you set the pattern fill?
>Will it simply fill with the default color? If so, how do you change the
>default color?
>
>Thanks,
>Jim
>
>"Bob Phillips" wrote:
>
>> You can set those cells up with conditional formatting, with a formula of
>> say =$A$1="abc" and set the pattern colour.
>>
>> --
>>
>> HTH
>>
>> RP
>>
>> "Jim Johnson" <(E-Mail Removed)> wrote in message
>> news:A95629B8-281E-44CA-972B-(E-Mail Removed)...
>> > Can I automatically shade a range of cells when certain text is typed
into
>> a
>> > specific cell?
>>
>>
>>

Thanks Bob, Frank and Myrna for your help.

"Myrna Larson" wrote:

> select A1:H1. Then Format/Conditional formatting. In the first box, select
> Formula Is. In the box to the right type =$G1="the text you want"
>
> Note the dollar sign in front of the G. That's critical.
>
> Then click on the Format button. There are tabs for font, border, and
> patterns. Make the settings you want.
>
> On Thu, 28 Oct 2004 22:10:05 -0700, "Jim Johnson"
> <(E-Mail Removed)> wrote:
>
> >Hi Bob,
> >
> >Can you give me an example of the formula if I wanted to shade cells A1 to
> >H1 depending on the text in cell G1? Also, how do you set the pattern fill?
> >Will it simply fill with the default color? If so, how do you change the
> >default color?
> >
> >Thanks,
> >Jim
> >
> >"Bob Phillips" wrote:
> >
> >> You can set those cells up with conditional formatting, with a formula of
> >> say =$A$1="abc" and set the pattern colour.
> >>
> >> --
> >>
> >> HTH
> >>
> >> RP
> >>
> >> "Jim Johnson" <(E-Mail Removed)> wrote in message
> >> news:A95629B8-281E-44CA-972B-(E-Mail Removed)...
> >> > Can I automatically shade a range of cells when certain text is typed
> into
> >> a
> >> > specific cell?
> >>
> >>
> >>
>
>

.... what a co-operative effort<vbg>

--

HTH

RP

"Jim Johnson" <(E-Mail Removed)> wrote in message
newsB48DBCF-7DAC-4CE8-91D6-(E-Mail Removed)...
> Thanks Bob, Frank and Myrna for your help.
>
> "Myrna Larson" wrote:
>
> > select A1:H1. Then Format/Conditional formatting. In the first box,
select
> > Formula Is. In the box to the right type =$G1="the text you want"
> >
> > Note the dollar sign in front of the G. That's critical.
> >
> > Then click on the Format button. There are tabs for font, border, and
> > patterns. Make the settings you want.
> >
> > On Thu, 28 Oct 2004 22:10:05 -0700, "Jim Johnson"
> > <(E-Mail Removed)> wrote:
> >
> > >Hi Bob,
> > >
> > >Can you give me an example of the formula if I wanted to shade cells A1
to
> > >H1 depending on the text in cell G1? Also, how do you set the pattern
fill?
> > >Will it simply fill with the default color? If so, how do you change
the
> > >default color?
> > >
> > >Thanks,
> > >Jim
> > >
> > >"Bob Phillips" wrote:
> > >
> > >> You can set those cells up with conditional formatting, with a
formula of
> > >> say =$A$1="abc" and set the pattern colour.
> > >>
> > >> --
> > >>
> > >> HTH
> > >>
> > >> RP
> > >>
> > >> "Jim Johnson" <(E-Mail Removed)> wrote in message
> > >> news:A95629B8-281E-44CA-972B-(E-Mail Removed)...
> > >> > Can I automatically shade a range of cells when certain text is
typed
> > into
> > >> a
> > >> > specific cell?
> > >>
> > >>
> > >>
> >
> >