Thanks for replyng and the user prompt. where do i find .misc. The only
forums i can find is charting, datamap etc.

"gb_S49" wrote:

> I am editing a spreadsheet which the original user used cell formatting to
> indicate postives. It looks very pretty!! Is there a function I can use,as
> it contains over 3000 row, to replace the shaded (filled but blank) cells
> with yes?