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