Auto Subtraction
Thread poster: sanj

sanj
Local time: 01:11
Aug 6, 2012

Dear Experts,

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...!


 

Sam Pinson  Identity Verified
United States
Local time: 13:41
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.


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Auto Subtraction

Advanced search






memoQ translator pro
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.

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search