M mjones Feb 12, 2008 #21 Select your cells A1:A100 for example and then conditionally format with: =MOD(A1,2)=1, then select your format color. Tyro Click to expand... That did it. Thanks!
Select your cells A1:A100 for example and then conditionally format with: =MOD(A1,2)=1, then select your format color. Tyro Click to expand... That did it. Thanks!
R Rick Rothstein \(MVP - VB\) Feb 12, 2008 #23 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
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