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