Excell cell format

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
Back
Top