Conditional Formatting
 

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!

Conditional Formatting
 

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!

Conditional Formatting
 

The cell will either have a value or a formula. Perhaps you can explain to
us what you have in your cell, and thus what you are trying to do.
--
David Biddulph

"lightbulb" wrote in message
...
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!

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!