Is there anyway, if I have a massive table of numbers, to replace the
negative with a different color background (to mark the cell), remove the
negative, do mathematical formulations (I have gotten this far) and THEN TO
REPLACE THE SHADED BACKGROUND WITH A NEGATIVE WHILE KEEPING THE NUMBER
WITHING THE CELL? In other words, once I have done the calculation, all what
once were negative numbers have different shaded backgrounds, I want to add
negatives BACK AGAIN, after my manipulations. Can I do this on a mass scale,
specific to the shaded cells while retaining the numbers in the cells?
I think I would think about adjusting those formulas--maybe using =abs().
Or use if all my numbers were in a single column, use a helper column to
manipulate the values--then use that helper column's cells in the formulas.
mine own wrote:
gt;
gt; Is there anyway, if I have a massive table of numbers, to replace the
gt; negative with a different color background (to mark the cell), remove the
gt; negative, do mathematical formulations (I have gotten this far) and THEN TO
gt; REPLACE THE SHADED BACKGROUND WITH A NEGATIVE WHILE KEEPING THE NUMBER
gt; WITHING THE CELL? In other words, once I have done the calculation, all what
gt; once were negative numbers have different shaded backgrounds, I want to add
gt; negatives BACK AGAIN, after my manipulations. Can I do this on a mass scale,
gt; specific to the shaded cells while retaining the numbers in the cells?
--
Dave Peterson
- Apr 21 Sat 2007 20:37
Please help
close
全站熱搜
留言列表
發表留言