Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 204
- Office Version
- 2019
- Platform
- Windows
Distribute Black text values of excel as compared to Red Text values, In the below example I want to distribute 45+15 = 60 among 1,3,4,5 but the sum of 1,3,4,5 is 66 so it can distribute the values up to 60 It will choose to distribute the values from Max values to Min values, so I want the C column like as shown in my example.
The red value is the negative value but that is converted into positive and having color red.
what should be the macro code ?
The red value is the negative value but that is converted into positive and having color red.
what should be the macro code ?