Hrishi
Board Regular
- Joined
- Jan 25, 2017
- Messages
- 56
- Office Version
- 365
- Platform
- Windows
Hello, I have few figures arranged in row. In columns 1 i have a figure for reference and I want to highlight figures from columns number 2 to 9 in such a way that summation of those highlighted figures from columns 2 to column under consideration shall be less than figure in column number 1 i.e. 30.
I tried to use sum($2:3)<$1, but ist not working, and if i drag it on right column number 3 in formula is not dragging along.
<colgroup><col width="98"><col width="85" span="8"><col width="85"><col width="85"></colgroup><tbody>
</tbody>
I tried to use sum($2:3)<$1, but ist not working, and if i drag it on right column number 3 in formula is not dragging along.
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
- 30 | 5 | 10 | 5 | 3 | 3 | 5 | 5 | 3 |
<colgroup><col width="98"><col width="85" span="8"><col width="85"><col width="85"></colgroup><tbody>
</tbody>