| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logical function
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")? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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")? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
| wild card with if logical function | Excel Worksheet Functions | |||
| Custom function | Excel Worksheet Functions | |||
| Logical Function Question | Excel Worksheet Functions | |||
| using logical functions as criteria with the SUMIF function | Excel Worksheet Functions | |||
Hybrid Mode
