SimonHughes
Well-known Member
- Joined
- Sep 16, 2009
- Messages
- 507
- Office Version
- 365
- Platform
- Windows
Hello, I am using Excel 2010
I have a column sorted from negative to positive values with conditional formatting to show negative (red), no change (orange) and positive (green).
Is it possible to create a formula to use these colours as the criteria? Can sumifs be used in some way?
I have a column sorted from negative to positive values with conditional formatting to show negative (red), no change (orange) and positive (green).
Is it possible to create a formula to use these colours as the criteria? Can sumifs be used in some way?
