Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Excel Bar Chart
  • Subtotal function in Excel
  • How To Filter Data in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • Use Data Form to input, edit and delete records in Excel

References

  • How to use Excel INDIRECT Function
  • How to use Excel TRANSPOSE Function
  • How to use Excel MMULT Function
  • Two-column Lookup in Excel
  • Perform case-sensitive Lookup in Excel

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation no punctuation
  • Excel Data validation date in specific year
  • Excel Data validation date in next 30 days
  • Excel Data validation only dates between

Highlight multiples of specific value in Excel

by

This tutorial shows how to Highlight multiples of specific value in Excel using the example below;

Formula

=MOD(A1,value)=0

Explanation

To highlight numbers that are multiples of a another number with conditional formatting, you can use a simple formula based on the MOD function.

In the example shown, the formula used to highlight multiples of 9 is:

=MOD(B4,$E$2)=0

Note: formula is entered relative to the “active cell” in the selection, cell B4 in this case.

How this formula works

Conditional formatting is evaluated for each cell in the range, relative to the upper left cell in the selection. In this case, the formula uses the MOD function to check the remainder of dividing the value in each cell, with the value in cell E2, which is 9. When the remainder is zero, we know that the value is an even multiple of the number 9, so the formula checks the result of MOD against zero.

When MOD returns zero, the expression returns TRUE and the conditional formatting applies. When MOD returns any other result, the expression returns FALSE conditional formatting is not applied.

Note E2 is input as an absolute address ($E$2) to prevent the reference from changing as the conditional formatting rule is evaluated across the selection B4:G11.

Post navigation

Previous Post:

COSH function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Data validation require unique number

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • OR function: Description, Usage, Syntax, Examples and Explanation
  • Invoice status with nested if in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • Not Equal To ‘<>‘ operator in Excel
  • Extract multiple matches into separate rows in Excel

Date Time

  • Calculate expiration date in Excel
  • How to determine year is a leap year in Excel
  • Add business days to date in Excel
  • How to calculate next day of week in Excel
  • Count day of week between dates in Excel

Grouping

  • Group times into 3 hour buckets in Excel
  • Map inputs to arbitrary values in Excel
  • How to randomly assign people to groups in Excel
  • Calculate conditional mode with criteria in Excel
  • Running count group by n size in Excel

General

  • How to calculate percent change in Excel
  • How to calculate percent variance in Excel
  • How to test a range for numbers in Excel
  • Subtotal by color in Excel
  • How to generate random date between two dates in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning