Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"