Conditional Formatting with Formula

Seba Robles

Board Regular
Joined
May 16, 2018
Messages
50
Hello all,

I'm trying to add a conditional format to a range of cells that contain number values.

The conditional format should check if the numbers on those ranges are a multiple of a number located in another fixed cell. (See screenshot example below)

1607212687511.png


Using the screenshot as reference, the multiplier or factor is located in cell B3, the cells ranging from E3:I6 are the ones that should contain the conditional format. The number in the range that are not a multiple of 10 would get highlighted.

I can't seem to figure it out, any help is greatly appreciated!!

Thanks in advance!
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,005
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Maybe...

Book2
BCDEFGHI
310612201710
4401314718
5142301518
6202414121
Sheet2
Cells with Conditional Formatting
CellConditionCell FormatStop If True
E3:I6Expression=MOD(E3,$B$3)<>0textNO
 
Solution

Mustafa Evans

New Member
Joined
Mar 18, 2010
Messages
35
Office Version
  1. 2010
Platform
  1. Windows
I would try the following where E4 is in the active cell.

Excel Formula:
=NOT(MOD(E4,$B$4))=0

Drag the formula to cover the requested range.
 
Last edited by a moderator:

Seba Robles

Board Regular
Joined
May 16, 2018
Messages
50

ADVERTISEMENT

Thank you both! Mark's response is what I was looking for, although Mustafa's does the thing, only in reverse. It highlights those that meet the pallet size, instead of the ones that don't.
 

Watch MrExcel Video

Forum statistics

Threads
1,128,015
Messages
5,628,146
Members
416,294
Latest member
McStuffins

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top