Thread: Please help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mine own
 
Posts: n/a
Default 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?