avisoft20
Board Regular
- Joined
- Sep 10, 2016
- Messages
- 63
Dear All,
I need your support.
I want the conditional formatting formula. I am trying to that
Conditions:
Sum of B2:f2 equal to or greater than A2, will be highlighted, Do not want to add a column for the sum of B2:f2
The result will be for :
Thanks, And Regards
Avisoft20
I need your support.
I want the conditional formatting formula. I am trying to that
Conditions:
Sum of B2:f2 equal to or greater than A2, will be highlighted, Do not want to add a column for the sum of B2:f2
A | B | C | D | F |
Total | Jan-20 | Feb-20 | March-20 | April-20 |
20 | 8 | 7 | 5 | 5 |
15 | 5 | 8 | 6 | 3 |
25 | 10 | 11 | 5 | 10 |
The result will be for :
Total | Jan-20 | Feb-20 | Mar-20 | Apr-20 |
20 | 8 | 7 | 5 | 5 |
15 | 5 | 8 | 6 | 3 |
25 | 10 | 11 | 5 | 10 |
Thanks, And Regards
Avisoft20