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.
Cookie settings

Technical forums » Office applications »
Auto Subtraction
Thread poster: sanj

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.
=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: 11:27
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:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
TM-Town
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 »

Recent posts | FAQ | Rules | Moderators | Article knowledgebase

Your current localization setting

English

Select a language

More languages...
Close search
Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search