Hi.

I want to be able to highlight a Row on my spreadsheet when one of the cells
contains the word "Yes".

I have tried a variety of things, including the Conditional Formatting
wizard but cant get it to work.

My Spreadsheet has the following columns:

A = Name, B = Attending, C = Deposit Paid, D = Balance Paid, E = Total Paid.

If Column B has Yes in it, I want the all 5 cells in the table to highlight
in a different colour.

Thanks in advance,
Steve.