ANOTHER dropdown question!

[Laura \( '_' \)]

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

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

 

[Bob Phillips]

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)

 

[Laura \( '_' \)]

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]

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 \( '_' \)]

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

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