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")?
|