View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Logical function

What if both cells are not divisible by 5? It that ok?

=AND(COUNT(A2,B2)=2,OR(MOD(A2,5)0,MOD(B2,5)0))

Biff

"Lavanya" wrote in message
...
Hi,
I am trying to apply conditional formatting if one of two column is not
divisible by 5. which logical function should i be using? can someone
help?
Can i say something like IF(=or(A2/5, B2/5), "True")?