Chartridge
New Member
- Joined
- Apr 12, 2013
- Messages
- 1
Hello,
I have recently upgraded to Office Professional 2010 and am experiencing issues with conditional formatting of a sheet created in XP (2002). The attached sample shows a test sheet.
What I wish to achieve is: When a user inputs a pre-determined number in E6 and then numbers in any of the cells in the range H6 and AD7 (March to Feb), the sum of these should equal the number in E6 (Due) and the number in AG6 (O/S) changes to 0 and the cell colour becomes green. If the sum is greater than E6, a negative number is displayed and the font becomes red.
At the same time, the number in cell E6 changes to white and the fill changes from red to green and, the fill colour in D6 'Members' also changes to green.
This works perfectly in 2002 but for reasons I don't understand, it doesn't in 2010 and I hope hope this makes sense and someone can enlighten me.
Regards
I have recently upgraded to Office Professional 2010 and am experiencing issues with conditional formatting of a sheet created in XP (2002). The attached sample shows a test sheet.
What I wish to achieve is: When a user inputs a pre-determined number in E6 and then numbers in any of the cells in the range H6 and AD7 (March to Feb), the sum of these should equal the number in E6 (Due) and the number in AG6 (O/S) changes to 0 and the cell colour becomes green. If the sum is greater than E6, a negative number is displayed and the font becomes red.
At the same time, the number in cell E6 changes to white and the fill changes from red to green and, the fill colour in D6 'Members' also changes to green.
This works perfectly in 2002 but for reasons I don't understand, it doesn't in 2010 and I hope hope this makes sense and someone can enlighten me.
Regards
Last edited: