Conditional Formating to Show Numbers NOT Divisible by another
This did not work. Is it maybe because I need it to cover several cells
(A1.A7)? The conditional formatting would need to look at all of the amounts
in the cells and identify the cells that are not divisible by 54.
--
Karrie
"T. Valko" wrote:
Try this:
A1 = 108
Select cell A1
Goto the menu FormatConditional Formatting
Formula Is: =AND(A1<0,MOD(A1,54)=0)
Click the Format button
Select the desired style(s)
OK out
--
Biff
Microsoft Excel MVP
"Sliver Rayne" wrote in message
...
I want to add conditional formatting to show me any number that is
divisible
by 54. So if the number is 108, it would be ok because it's divisible by
108
but if its 53, I want it highlighted because it is not divisible by 54
Thanks, in advance, for any assistance.
--
Karrie
|