Hi Laura

You could use Format/Conditional Formatting. Select the whole row, go to
Format/Conditional Formatting and in the first box select 'Formula is'. In
the next box type
=$A2="N"
assuming your N is going to be in A2. Next select your format and away you
go!

Andy.
(Warrington, England!)
"Laura ( '_' )" wrote in message
...
Blank
Hello

Firstly I am sorry for multi-posting, but I didn't understand the answer I
got in the main excel newsgroup.
#Here is my question:-

I have a drop down feature with a list of 'yes' and 'no' in my E Column.
Is
there any way I could enter a formula or something so if the answer
selected
is 'no' the whole row turns a different colour.

I hope I have explained myself okay.

Thanks for your help --
@---}--
Laura..... :)
Liverpool, England

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