Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |