Change formatting of a cell based on results in 10 other cells

Hello.

I have a spreadsheet (Office 2007) which has 10 columns that have conditional formatting at the bottom of each one. I want to format another cell to display a message when the conditions in all 10 of those cells is "YES".

I have tried many combinations and formulae using conditional formatting, but none works.

And I wouldn't have a clue as to how to do this using a macro.

Can anybody help. please?

Thanks Ron! That works perfectly. Shows that I needed to think the problem through from a different perspective.

I appreciate your help.