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!
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
14,050
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,129,696
Messages
5,637,863
Members
416,986
Latest member
zmartee

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