Excell cell format

[Guest]

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?

 

[JE McGimpsey]

Not sure how the original user used cell formatting to indicate
positives, but you could use Custom Formatting:


Format/Cells/Number/Custom "Yes";;;@

will display "Yes" in any cell with a positive number as a value.

If you need the *value* to be "Yes", you'll need to explain what gives
the cells the value in the first place.