Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |