Conditional Formatting

  • Thread starter Thread starter lightbulb
  • Start date Start date
L

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