Conditional Formatting with Formula

Seba Robles

Board Regular
Joined
May 16, 2018
Messages
71
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Maybe...

Book2
BCDEFGHI
310612201710
4401314718
5142301518
6202414121
Sheet2
Cells with Conditional Formatting
CellConditionCell FormatStop If True
E3:I6Expression=MOD(E3,$B$3)<>0textNO
 
Upvote 0
Solution
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:
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,954
Members
448,535
Latest member
alrossman

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
Back
Top