Thread poster: sanj
i want Auto Subtraction between A1:A1000 - B1:B1000 Value apply to C1:C1000 in conditional formatting.
Continue to A1000-B1000 At C1 to C1000
please help me...!
| | Sam Pinson
Local time: 11:27
Russian to English
| Drag handle in lower right corner || Aug 7, 2012 |
All you need to do is:
1) specify your formula for the first cell, e.g. "=A1-B1";
2) select the cell where you entered the formula;
3) drag the lower right corner down 1,000 rows.
The formula will automatically be updated.
To report site rules violations or get help, contact a site moderator:
You can also contact site staff by submitting a support request »