View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sliver Rayne Sliver Rayne is offline
external usenet poster
 
Posts: 5
Default Conditional Formating to Show Numbers NOT Divisible by another

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