View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DebbieV DebbieV is offline
external usenet poster
 
Posts: 20
Default Apply format to row if yes response

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