Conditional formatting

[RAM]

Hi,

I have a column, E13:E31, where I input numbers. I could need a conditional formatting if the sum of E21:E23 doesn't return a even number. There are no formulas within the column. The sum of E21:E23 must be summed up within the condition or beside the sheet.

Thanks,

RAM

 

[shippey121]

take a look at the "ISEVEN" function something like

=ISEVEN(SUM(e21:e23))

HTH

 

[Norie]

RAM

Which range do you want to format?

=MOD(SUM($E$21:$E$23),2)=0

shippey

Good idea, but you can't use functions from the Analysis ToolPak in conditional formatting.

 

[Scott Huish]

Like Norie asked, what range do you want to format?

But since you want to format if the result is odd:

=MOD(SUM($E$21:$E$23),2)=1

 

[RAM]

Thanks guys,

Good question. I want to format E21:E23 if they don't add up to an even number.

RAM

 

[Norie]

RAM

Well HOTPEPPER's formula should do that.

 

[RAM]

Thanks,

I'll try it tonight.

RAM

 

[shippey121]

thanks for your pointer norie,

i was wondering why i couldnt accept it,

the formula i entered would have displayed TRUE in the cell it was entered in, i thought mabye that would be ok, then conditional formating could be set to cell value = true

just a workaround but you guys always come up with the bes solutions,

 

[RAM]

RAM

Well HOTPEPPER's formula should do that.

Thank you guys. Worked perfectly. Got just what I wanted

RAM