APPLE NUMBERS - Spreadsheet

NUMBERS - Spreadsheet APPLE - Free user manual and instructions

Find the device manual for free NUMBERS APPLE in PDF.

📄 632 pages English EN ⬇ Download 💬 AI Question ❓ 2 questions
Notice APPLE NUMBERS - page 319
319 / 632
View the manual : Français FR English EN
Pick your language and provide your email: we'll send you a specifically translated version.

User questions about NUMBERS APPLE

2 questions about this device. Answer the ones you know or ask your own.

Ask a new question about this device

The email remains private: it is only used to notify you if someone responds to your question.

How to automatically turn a cell red in Numbers when a date is 15 days from the current date?
Frequently Asked Questions - 29/12/2025
Response Notice-Facile

To automatically turn a cell red in Numbers when the date it contains is 15 days from the current date, you can use the conditional formatting feature. Here are the steps to follow:

  1. Select the cell or range of cells containing the dates to check.
  2. In the toolbar, click on the Format button (at the top right).
  3. In the panel that opens, choose Conditional Formatting.
  4. Click on Add a Rule.
  5. In the dropdown menu of rules, select Date is.
  6. Choose the option "in the next 15 days" or "in the 15 days before" depending on whether you want to include future or past dates.
  7. Then set the formatting style, for example, the text or background color to red.
  8. Confirm by clicking on Done.

This rule will automatically apply the red color to cells whose date is within 15 days of the current date, thus facilitating the visualization of upcoming deadlines.

Respond (be the first)
What separator should be used between arguments in a formula in Numbers, a comma or a semicolon?
Frequently Asked Questions - 29/12/2025
Response Notice-Facile

In Apple's Numbers, the separator used between the arguments of a formula mainly depends on your regional settings, particularly the decimal separator. Numbers automatically inserts a comma (,) between arguments when you select cells, but you need to replace it with a semicolon (;) if the decimal separator for your location is a comma (as is the case in French).

For example, in France where the decimal separator is the comma, you should write:

=SUM(A1;A2;A3)

and not:

=SUM(A1,A2,A3)

This distinction is important because using a comma as an argument separator in a French-speaking locale would create ambiguity: the comma would be both your decimal separator and your argument separator. That is why Numbers allows you to replace the automatically inserted comma with a semicolon when adding cell references.

In summary: if your system uses a comma as the decimal separator (French, Belgian, Swiss French localization, etc.), use the semicolon to separate the arguments. If you are using an English-speaking locale where the decimal separator is the point, the comma can generally be retained.

Respond (be the first)

Download the instructions for your Spreadsheet in PDF format for free! Find your manual NUMBERS - APPLE and take your electronic device back in hand. On this page are published all the documents necessary for the use of your device. NUMBERS by APPLE.

USER MANUAL NUMBERS APPLE

ET(expression; [expression; ...])

NBVAL(A1:E1) revoie 5.

NBVAL(A2:E2) revoie 5.

NBVAL(A3:E3) revoie 5.

NBVAL(A4:E4) revoie 5.

NBVAL(A5:E5) revoie 2.

NBVAL(1; "a"; VRAI; FAUX) renvoie 4.

NBVAL(1; SOMME(4; 5)) revoie 2.

NB.VIDE

NB.SI(intervalle-test; condition)

NB.SI(A1:A8; " >=4 ") revoie 5.

COUPDAYBS

ARRONDI.AU.MULTIPLE(4,4999; 3) revoie 3.

ARRONDI.AU.MULTIPLE(4,5;3) renvoie 6.

OU(expression; [expression; ...])

RANG(4; A6:E7; 1) revoie 4.

SOMMEPROD({1;2};{3;4})=3+8=11.

SOMME.CARRÉS

Table of contents Click a title to access it
Manual assistant
Powered by Anthropic
Waiting for your message
Product information

Brand : APPLE

Model : NUMBERS

Category : Spreadsheet