See one potential answer in .misc.

Please don't post the same message in multiple groups. It tends to
fragment any answers you give, and potentially wastes the time of those
providing a solution that has already been given.

See http://cpearson.com/excel/newposte.htm for tips on using these
groups effectively.


In article ,
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?