ANOTHER dropdown question!

BlankHello again,
Im sorry for asking lots of questions, but I am attempting my first
spreadsheet and I am stuck :(
I have now been able to do a drop down feature (thanks to Bob and Roger). I
would now like to know:-

In my list of names in the drop down feature, if I selected a certain name,
is there any way I do enter a formula or something so that whole row turns a
different colour.

Have I explained myself okay??

Thanks for your help anyway :)

--
@---}--
Laura..... :)
Liverpool, England

"Do you know where you're going to?"

Roger
Fri Nov 25 04:37:27 CST 2005

Hi Laura

You need Conditional Formatting
Select the range of cells to which you wish to apply the colour.
Format>Conditional Formatting>dropdown to Select Formula is> in white pane
type =A1<>""
Select Format and choose Patterns then select colour required.
Then, if Cell A1 is empty the cells won't be coloured. If there is anything
in cell A1 it will. Because the cell value is relative not absolute, it will
look at A2 for row2 etc.

If the cell you are testing is not in column A, change the reference
accordingly.

I will now be off-line for some while. Good luck.

Regards

Roger Govier


Laura ( '_' ) wrote:
> BlankHello again,
> Im sorry for asking lots of questions, but I am attempting my first
> spreadsheet and I am stuck :(
> I have now been able to do a drop down feature (thanks to Bob and Roger). I
> would now like to know:-
>
> In my list of names in the drop down feature, if I selected a certain name,
> is there any way I do enter a formula or something so that whole row turns a
> different colour.
>
> Have I explained myself okay??
>
> Thanks for your help anyway :)
>

Bob
Fri Nov 25 05:14:35 CST 2005

I think you need a formula of

=$A2=$H$1

which assumes the highlighting row is 2, the dropdown is in H1, and the name
in row 2 is in column A.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Roger Govier" <roger@nospamtechnology4u.co.uk> wrote in message
news:4386E967.20803@nospamtechnology4u.co.uk...
> Hi Laura
>
> You need Conditional Formatting
> Select the range of cells to which you wish to apply the colour.
> Format>Conditional Formatting>dropdown to Select Formula is> in white pane
> type =A1<>""
> Select Format and choose Patterns then select colour required.
> Then, if Cell A1 is empty the cells won't be coloured. If there is
anything
> in cell A1 it will. Because the cell value is relative not absolute, it
will
> look at A2 for row2 etc.
>
> If the cell you are testing is not in column A, change the reference
> accordingly.
>
> I will now be off-line for some while. Good luck.
>
> Regards
>
> Roger Govier
>
>
> Laura ( '_' ) wrote:
> > BlankHello again,
> > Im sorry for asking lots of questions, but I am attempting my first
> > spreadsheet and I am stuck :(
> > I have now been able to do a drop down feature (thanks to Bob and
Roger). I
> > would now like to know:-
> >
> > In my list of names in the drop down feature, if I selected a certain
name,
> > is there any way I do enter a formula or something so that whole row
turns a
> > different colour.
> >
> > Have I explained myself okay??
> >
> > Thanks for your help anyway :)
> >

Laura
Fri Nov 25 05:22:57 CST 2005

Thankyou very much but I cant get it to work :(

I have the dropdowns in column E. And in that *same* column when I select
'no' I want the row that it is on to change.

Does that make sense.

You've been very helpful so far thankyou

--
@---}--
Laura..... :)
Liverpool, England

"Do you know where you're going to?"
"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uAo8rFb8FHA.1140@tk2msftngp13.phx.gbl...
> I think you need a formula of
>
> =$A2=$H$1
>
> which assumes the highlighting row is 2, the dropdown is in H1, and the
name
> in row 2 is in column A.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Roger Govier" <roger@nospamtechnology4u.co.uk> wrote in message
> news:4386E967.20803@nospamtechnology4u.co.uk...
> > Hi Laura
> >
> > You need Conditional Formatting
> > Select the range of cells to which you wish to apply the colour.
> > Format>Conditional Formatting>dropdown to Select Formula is> in white
pane
> > type =A1<>""
> > Select Format and choose Patterns then select colour required.
> > Then, if Cell A1 is empty the cells won't be coloured. If there is
> anything
> > in cell A1 it will. Because the cell value is relative not absolute, it
> will
> > look at A2 for row2 etc.
> >
> > If the cell you are testing is not in column A, change the reference
> > accordingly.
> >
> > I will now be off-line for some while. Good luck.
> >
> > Regards
> >
> > Roger Govier
> >
> >
> > Laura ( '_' ) wrote:
> > > BlankHello again,
> > > Im sorry for asking lots of questions, but I am attempting my first
> > > spreadsheet and I am stuck :(
> > > I have now been able to do a drop down feature (thanks to Bob and
> Roger). I
> > > would now like to know:-
> > >
> > > In my list of names in the drop down feature, if I selected a certain
> name,
> > > is there any way I do enter a formula or something so that whole row
> turns a
> > > different colour.
> > >
> > > Have I explained myself okay??
> > >
> > > Thanks for your help anyway :)
> > >
>
>

Bob
Fri Nov 25 06:55:13 CST 2005

Select all the rows, let's say starting at row 2
Format>Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of =LOWER($E2)="no"
Click Format
Select Pattern
Choose a colour
OK
OK

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Laura ( '_' )" <laura@invalid.example.com> wrote in message
news:e4OW%23Jb8FHA.1276@TK2MSFTNGP09.phx.gbl...
> Thankyou very much but I cant get it to work :(
>
> I have the dropdowns in column E. And in that *same* column when I select
> 'no' I want the row that it is on to change.
>
> Does that make sense.
>
> You've been very helpful so far thankyou
>
> --
> @---}--
> Laura..... :)
> Liverpool, England
>
> "Do you know where you're going to?"
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:uAo8rFb8FHA.1140@tk2msftngp13.phx.gbl...
> > I think you need a formula of
> >
> > =$A2=$H$1
> >
> > which assumes the highlighting row is 2, the dropdown is in H1, and the
> name
> > in row 2 is in column A.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "Roger Govier" <roger@nospamtechnology4u.co.uk> wrote in message
> > news:4386E967.20803@nospamtechnology4u.co.uk...
> > > Hi Laura
> > >
> > > You need Conditional Formatting
> > > Select the range of cells to which you wish to apply the colour.
> > > Format>Conditional Formatting>dropdown to Select Formula is> in white
> pane
> > > type =A1<>""
> > > Select Format and choose Patterns then select colour required.
> > > Then, if Cell A1 is empty the cells won't be coloured. If there is
> > anything
> > > in cell A1 it will. Because the cell value is relative not absolute,
it
> > will
> > > look at A2 for row2 etc.
> > >
> > > If the cell you are testing is not in column A, change the reference
> > > accordingly.
> > >
> > > I will now be off-line for some while. Good luck.
> > >
> > > Regards
> > >
> > > Roger Govier
> > >
> > >
> > > Laura ( '_' ) wrote:
> > > > BlankHello again,
> > > > Im sorry for asking lots of questions, but I am attempting my first
> > > > spreadsheet and I am stuck :(
> > > > I have now been able to do a drop down feature (thanks to Bob and
> > Roger). I
> > > > would now like to know:-
> > > >
> > > > In my list of names in the drop down feature, if I selected a
certain
> > name,
> > > > is there any way I do enter a formula or something so that whole row
> > turns a
> > > > different colour.
> > > >
> > > > Have I explained myself okay??
> > > >
> > > > Thanks for your help anyway :)
> > > >
> >
> >
>
>

Laura
Fri Nov 25 07:04:02 CST 2005


Sorted!
Thankyou :-D
--
@---}--
Laura..... :)
Liverpool, England

"Do you know where you're going to?"
"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:Ouot%239b8FHA.808@TK2MSFTNGP09.phx.gbl...
> Select all the rows, let's say starting at row 2
> Format>Conditional Formatting
> Change Condition 1 to Formula Is
> Add a formula of =LOWER($E2)="no"
> Click Format
> Select Pattern
> Choose a colour
> OK
> OK
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Laura ( '_' )" <laura@invalid.example.com> wrote in message
> news:e4OW%23Jb8FHA.1276@TK2MSFTNGP09.phx.gbl...
> > Thankyou very much but I cant get it to work :(
> >
> > I have the dropdowns in column E. And in that *same* column when I
select
> > 'no' I want the row that it is on to change.
> >
> > Does that make sense.
> >
> > You've been very helpful so far thankyou
> >
> > --
> > @---}--
> > Laura..... :)
> > Liverpool, England
> >
> > "Do you know where you're going to?"
> > "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> > news:uAo8rFb8FHA.1140@tk2msftngp13.phx.gbl...
> > > I think you need a formula of
> > >
> > > =$A2=$H$1
> > >
> > > which assumes the highlighting row is 2, the dropdown is in H1, and
the
> > name
> > > in row 2 is in column A.
> > >
> > > --
> > >
> > > HTH
> > >
> > > RP
> > > (remove nothere from the email address if mailing direct)
> > >
> > >
> > > "Roger Govier" <roger@nospamtechnology4u.co.uk> wrote in message
> > > news:4386E967.20803@nospamtechnology4u.co.uk...
> > > > Hi Laura
> > > >
> > > > You need Conditional Formatting
> > > > Select the range of cells to which you wish to apply the colour.
> > > > Format>Conditional Formatting>dropdown to Select Formula is> in
white
> > pane
> > > > type =A1<>""
> > > > Select Format and choose Patterns then select colour required.
> > > > Then, if Cell A1 is empty the cells won't be coloured. If there is
> > > anything
> > > > in cell A1 it will. Because the cell value is relative not absolute,
> it
> > > will
> > > > look at A2 for row2 etc.
> > > >
> > > > If the cell you are testing is not in column A, change the reference
> > > > accordingly.
> > > >
> > > > I will now be off-line for some while. Good luck.
> > > >
> > > > Regards
> > > >
> > > > Roger Govier
> > > >
> > > >
> > > > Laura ( '_' ) wrote:
> > > > > BlankHello again,
> > > > > Im sorry for asking lots of questions, but I am attempting my
first
> > > > > spreadsheet and I am stuck :(
> > > > > I have now been able to do a drop down feature (thanks to Bob and
> > > Roger). I
> > > > > would now like to know:-
> > > > >
> > > > > In my list of names in the drop down feature, if I selected a
> certain
> > > name,
> > > > > is there any way I do enter a formula or something so that whole
row
> > > turns a
> > > > > different colour.
> > > > >
> > > > > Have I explained myself okay??
> > > > >
> > > > > Thanks for your help anyway :)
> > > > >
> > >
> > >
> >
> >
>
>