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 ( '_' )" <[email protected]> wrote in message
news:ezPb8%[email protected]...
> 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?"
>
>