View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Change conditional formatting if the number is odd or even?

Information Adding:
Some version Excel can't use "ISODD" worksheet function directly, such as
2003.
It needs to click menu "Tool"-"Add-in"-"Analysis tool", then you can use
it.
(Since I haven't English version, I don't what's exact name is.)

If this operation still doesn't work, you can use mod instead of "ISODD"
function.
=MOD(A1,2)


Yes, this is a better way! Thanks...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion