 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / February 2008Conditional Format if cell value is odd
Hi all, Does anyone know how to do this? Thanks a bunch, Michele Please state your question in the body of the message, not in the subject. =ISODD(A1) Tyro > Hi all, > [quoted text clipped - 3 lines] > > Michele ISODD is not a standard function - requires ATP to be installed with versions before XL2007. Pete > Please state your question in the body of the message, not in the subject. > [quoted text clipped - 11 lines] > > - Show quoted text - So? Install ATP. Tyro ISODD is not a standard function - requires ATP to be installed with versions before XL2007. Pete On Feb 12, 1:12 am, "Tyro" <T...@hotmail.com> wrote: > Please state your question in the body of the message, not in the subject. > [quoted text clipped - 15 lines] > > - Show quoted text - You can't directly use functions from the ATP in conditional formatting.  SignatureBiff Microsoft Excel MVP > So? Install ATP. > [quoted text clipped - 26 lines] >> >> - Show quoted text - I use Excel 2007. > You can't directly use functions from the ATP in conditional formatting. > [quoted text clipped - 28 lines] >>> >>> - Show quoted text - > I use Excel 2007. > [quoted text clipped - 34 lines] > > >>> - Show quoted text - Hi all, I'm using Excel 2003 (sorry, need to add that now), and the conditonal format is on a range of cells so only the cells with odd numbers will have a different color. Sorry that I didn't clarify better. Michele Select your cells A1:A100 for example and then conditionally format with: =MOD(A1,2)=1, then select your format color. Tyro >> I use Excel 2007. >> [quoted text clipped - 45 lines] > > Michele > Select your cells A1:A100 for example and then conditionally format with: > =MOD(A1,2)=1, then select your format color. [quoted text clipped - 54 lines] > > > Michele That did it. Thanks! You're welcome Tyro >> Select your cells A1:A100 for example and then conditionally format with: >> =MOD(A1,2)=1, then select your format color. [quoted text clipped - 57 lines] > > That did it. Thanks! If the cell value you want to check is A1, then: formula is =mod(A1,2) = 0 hope that helps Carlo > Hi all, > [quoted text clipped - 3 lines] > > Michele That formula produces TRUE if the cell value is even, not odd. Tyro If the cell value you want to check is A1, then: formula is =mod(A1,2) = 0 hope that helps Carlo On Feb 12, 10:05 am, mjones <mich...@quality-computing.com> wrote: > Hi all, > [quoted text clipped - 3 lines] > > Michele If you do not wish to install the Analysis Toolpak, you may use =MOD(A1,2)<>0 to determine if a cell is odd and =MOD(A1,2)=0 to determine if a cell is even Tyro > Hi all, > [quoted text clipped - 3 lines] > > Michele > If you do not wish to install the Analysis Toolpak, you may use > =MOD(A1,2)<>0 to determine if a cell is odd and =MOD(A1,2)=0 to determine [quoted text clipped - 9 lines] >> >> Michele > =MOD(A1,2)<>0 to determine if a cell is odd Or even... =MOD(A1,2)=1 Rick Yes indeedy! Tyro >> =MOD(A1,2)<>0 to determine if a cell is odd > > Or even... =MOD(A1,2)=1 > > Rick In the future, I shall attempt to exhaust all possibilities, just to make sure that no stone is left unturned in an answer <g> Tyro >> =MOD(A1,2)<>0 to determine if a cell is odd > > Or even... =MOD(A1,2)=1 > > Rick I also understand that division by 2 can produce a remainder of only 0 or 1. Tyro >> =MOD(A1,2)<>0 to determine if a cell is odd > > Or even... =MOD(A1,2)=1 > > Rick Assuming of course that the number being divided is an integer. Tyro >> =MOD(A1,2)<>0 to determine if a cell is odd > > Or even... =MOD(A1,2)=1 > > Rick > Assuming of course that the number being divided is an integer. Being an integer was a requirement of the original question (Is value odd?). Rick I don't know what the OP has in the cell. Tyro >> Assuming of course that the number being divided is an integer. > > Being an integer was a requirement of the original question (Is value > odd?). > > Rick All I was saying was... if the cell's content is not an integer, the question "Is it odd?" would make no sense (by definition, only integers can be odd or even). Rick >I don't know what the OP has in the cell. > [quoted text clipped - 6 lines] >> >> Rick You may also use =ISODD(A1) if you are using Excel 2007. You did not state what version you are using. Tyro > Hi all, > [quoted text clipped - 3 lines] > > Michele |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.