Coloring cells

**ianma** · 05-26-2008, 06:19 AM

Hi,

Am trying to run a marco which inables the summation cell to turn yellow if the number is even, or red if the number odd.

Any sort off help would be great thanks

**VBA Noob** · 05-26-2008, 06:26 AM

No need for code

Make sure you have the Analysis ToolPak installed

http://www.bettersolutions.com/excel...P514412778.htm

Then use conditional formatting with a formula like

http://www.contextures.com/xlCondFormat01.html

For odd condtion

=ISODD(A1)

For even condition

=ISEVEN(A1)

or without the Analysis ToolPak installed

=MOD(A1,2)=0

=MOD(A1,2)=1

VBA Noob

**ianma** · 05-26-2008, 06:36 AM

Many thanks for that info VBA Noob

Coloring cells

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Coloring cells

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions