Solved Bold a cell if another cell is an odd number

September 21, 2011 at 08:29:07
Specs: Windows 7
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.


See More: Bold a cell if another cell is an odd number

Report •


#1
September 21, 2011 at 11:45:02
✔ Best Answer
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.


Report •

#2
September 21, 2011 at 12:38:27
Thank you that worked great.

Report •
Related Solutions


Ask Question