i want Auto Subtraction between A1:A1000 - B1:B1000 Value apply to C1:C1000 in conditional formatting.
=A1-B1
=A2-B2
=A3-B3
=A4-B4
=A5-B5
=A6-B6
=A7-B7
=A8-B8
=A9-B9
=A10-B10
=A11-B11
=A12-B12
=A13-B13
=A14-B14
=A15-B15
=A16-B16
=A17-B17
=A18-B18
=A19-B19
=A20-B20
Continue to A1000-B1000 At C1 to C1000
please help me...!
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Sam Pinson United States Local time: 23:30 Member (2011) Russian to English
Drag handle in lower right corner
Aug 7, 2012
Hi.
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.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
To report site rules violations or get help, contact a site moderator:
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.
With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.
SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.