Hi...

I've just written 1000 questions for a user to select from. Having just
written them I don't seem to be able to apply conditional formatting to them.
Basically, if any line within the worksheet contains a YES, the line on which
it is located will go Bold Red font? Is this poss.

I did try highlighting the entire lot but it seemed to offset the formula
and wouldn't work.

Thanks in advance

Gordon...