I would think this is easy but I can't figure it out. In a spread sheet I have column A with a number and columns B and C auto populate with text determined by what number was entered in A. What I am wanting to do is format the cells in B to bold only if the number in A is odd. Likewise column C would bold if the number is even. Again this should be easy I would think.

Use Conditional Formatting with these Rules: =MOD(A1,2) = 1 which will be TRUE for odd numbers

=MOD(A1,2) = 0 which will be TRUE for even numbers

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thank you that worked great.

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History