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?