Conditional Formating with even numbers

**sher_amf** · 05-08-2009, 08:53 AM

i have 2 columns the first is the transaction number and second column is the description

i want to make that all even transaction number will highlight the whole row... how do i make that with conditional formatting? or are there other alternatives?

**NBVC** · 05-08-2009, 08:59 AM

Select entire range and go to Format|Conditional Formatting

Select Formula Is from 1st drop down and enter formula: =MOD($A1,2)=0

where A1 is top most cell in your selection containing transaction number. Change as necessary, but do not remove $ sign.. it fixes the column.

Click Format and choose highlight colour.

**Special-K** · 05-08-2009, 09:27 AM

If ever you need to determine even numbers and the computer language you're programming in doesnt have a MOD function this method will work:

IF INT(x/2)*2 = x THEN {it's an even number} ELSE {it's an odd number}

**sher_amf** · 05-08-2009, 09:38 AM

Originally Posted by NBVC

Select entire range and go to Format|Conditional Formatting

Select Formula Is from 1st drop down and enter formula: =MOD($A1,2)=0

where A1 is top most cell in your selection containing transaction number. Change as necessary, but do not remove $ sign.. it fixes the column.

Click Format and choose highlight colour.

i already tried what you said... i returns a value of true or false...

but is there a way that i can highlight the whole row which contains true?