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
|