I would do it like that:

Select your rows A:AG
(Maybe you don't need row 1, but I don't know that)

go to format, conditional formatting...
select formula and enter:
=$P3="yes"

the $ is the important part :)

then choose your format and hit ok

hth
Carlo

On Jan 23, 10:43*am, DebbieV wrote:
Hi
I have a list of records that if there is a response in one cell that
the row is formatted differently.

For example

My record is in A3:AG3 and in P3 there is a yes/no validation list.
If the answer is yes I would like to have the record formatted to
bright red & bold.

Can anyone help. *I have tried to do it in conditional formatting but
I must be missing something.
cheers
Debbie