Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Dal123

macrumors 6502a
Original poster
Oct 23, 2008
903
0
England
I'm using excel 2011 and I have a value in say D147:

which is the value of (D140 + (C50-C49)

How do I get the cells that have been subtracted a certain colour (say orange). If possible as well; to get D140 green. Obviously I am using many cells and this is a simplified version.

Any help greatly appreciated.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.