Please help
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?
|