Conditional Formatting Cells Odd Even

Published:

Updated:

Enter this formula in the "Conditional Formatting"

Excel

Format>Conditional Formatting

=MOD(A1,2)=1  (Odd)  1st Condition  Green

=MOD(A1,2)=0  (Even) 2nd Condition  Blue

 

Cell A1 would be Position 1

Use the Format Painter (Paint Brush Icon) on the Menu Bar to format all your positons or cells that you would like to format as Odd /Even

Entry #24

Comments

This Blog entry currently has no comments.

Post a Comment

Please Log In

To use this feature you must be logged into your Lottery Post account.

Not a member yet?

If you don't yet have a Lottery Post account, it's simple and free to create one! Just tap the Register button and after a quick process you'll be part of our lottery community.

Register