Conditional Formatting
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!
|