Conditional Formatting

[lightbulb]

Is there a way to set conditional formatting so that if a cell is multiplied
by another specified cell it formats as I set it to?

For example, I want the formatting I select (pink coloration) to apply if
the cell is multiplied by cell D46, I want it to be another color if
multiplied by D48, and another color if multiplied by D50.

Any suggestions?

Thanks!

 

[Sheeloo]

To format A1, you can try the following formulas in FORMULA IS;
=MOD(A1,$D$46)=0 for PINK format
=MOD(A1,$D$48)=0 for second color
=MOD(A1,$D$50)=0 for third color

This will work as long as D46, D48, and D50 are not multiples of each other.

 

[Luke M]

Note also that this only works if the number you are multiplying D46 by is
not a decimal.
=MOD(1*1.5,1)=0

evaluates to FALSE