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