Conditional formatting a column for even numbers

G

greg7468

Hello all, could you please tell me how I would use conditiona
formating for a column of data so that all the even numbers ar
highlighted.
Thanks for your help
 
T

Trevor Shuttleworth

Greg

select the column and use:

Formula 1: =AND(ISNUMBER(A1),MOD(A1,2)=0)

assuming it is column A you want to format.

Regards

Trevor
 
B

Bob Phillips

=MOD(A1,2)=0

should be enough

--

HTH

RP

Trevor Shuttleworth said:
Greg

select the column and use:

Formula 1: =AND(ISNUMBER(A1),MOD(A1,2)=0)

assuming it is column A you want to format.

Regards

Trevor
Click to expand...
 
T

Trevor Shuttleworth

Bob

Depends if you pre-select the column like I did. Then blank cells also get
formatted. Hence the additional ISNUMBER check.

Regards

Trevor
 
B

Bob Phillips

Hi Trevor,

I see why you did it now :)

Bob

Trevor Shuttleworth said:
Bob

Depends if you pre-select the column like I did. Then blank cells also get
formatted. Hence the additional ISNUMBER check.

Regards

Trevor
Click to expand...
 
Top