How do I do a conditional formatting option based on if the number in the
referenced cell is odd or even? For example, if the cell is 16, text color
it black, if the cell is 15, text color it red.

Select the cells to be ConditionalFormatted, then use the following
'formula'...

=ISODD()

...then set the Font color as desired.

The even values will be the default color unless you set another rule otherwise
using =ISEVEN().

--
Garry

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