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
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sheeloo" wrote:

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.

"lightbulb" wrote:

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!