close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()