Welcome Guest
( Log In | Register )
The time is now 4:26 pm
You last visited January 24, 2017, 4:10 pm
All times shown are
Eastern Time (GMT-5:00)

Conditional Formatting Cells Odd Even

Published:

Last Edited: December 13, 2005, 1:54 pm

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.

You must be a Lottery Post member to post comments to a Blog.

Register for a FREE membership, or if you're already a member please Log In.