Seba Robles
Board Regular
- Joined
- May 16, 2018
- Messages
- 71
- Office Version
- 2019
- 2016
- Platform
- 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)
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!
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)
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!