Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I hate it when it is hard to describe the problem...the answer is probably
easy though, I just need pointing in the correct direction. Column A is for the customer to enter his quantity ordered. This number could be ZERO if he is not ordering a specific product or it could be multiples of the minimum case lot. Column B has the minimum case lot. If a number is entered into Col A how do I raise a flag if it is not at least the minimum in Col B. I don't need to make sure that it is the correct multiple of the minimum...just that it is equal to or greater than the minimum IFF it is not a zero. Any and all suggestions will be appreicated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |