Auto Subtraction
Thread poster: sanj

Local time: 22:57
Aug 6, 2012

Dear Experts,

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  Identity Verified
United States
Local time: 11:27
Member (2011)
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 »

Auto Subtraction

Advanced search

BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
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.

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search