This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
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: 00:13 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)
Manage your TMs and Terms ... and boost your translation business
Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.