Guys

bit of help required.

i need to conditionally format a cell say A10 that meets the following condtions

either A2 OR B2 contains the word YES and C2 contains the word NO.

so to recap if either of cells A2 or B2 contains YES and C2 contains NO then I want to color the cell A10 blue

any help appreciated

Barbara