Another suggestion, please

[Jono]

Hello,

I have a spreadsheet of addresses. Following previous assistance in this
group, the sheet is sorted perfectly......nearly.

The addresses are numerically sorted - 1 Anystreet, 2 Anystreet, 3 Anystreet
etc. The house numbers are in separate cells from the road name.

What I would like to do is apply some conditional formatting - I would like
to embolden an entire row, should the house number be an even number.

Alternatively, if it's possible to sort all the odds together, and all the
evens together, I can apply the formatting manually.

What would be the formula that would return the value "odd" if cell F1
contained an odd number?

Thanks

 

[Andy B]

Hi

Try:
=IF(ISODD(A2),"Odd","Even")

 

[Don Guillett]

for the sake of the archives, please use meaningful subject lines

 

[Jono]

Don Guillett wrote:
|| for the sake of the archives, please use meaningful subject lines
||
|| --
|| Don Guillett
|| SalesAid Software
|| (e-mail address removed)
|| ||| Hello,
|||
||| I have a spreadsheet of addresses. Following previous assistance in
||| this group, the sheet is sorted perfectly......nearly.
|||
||| The addresses are numerically sorted - 1 Anystreet, 2 Anystreet, 3
||| Anystreet etc. The house numbers are in separate cells from the
||| road name.
|||
||| What I would like to do is apply some conditional formatting - I
||| would like to embolden an entire row, should the house number be an
||| even number.
|||
||| Alternatively, if it's possible to sort all the odds together, and
||| all the evens together, I can apply the formatting manually.
|||
||| What would be the formula that would return the value "odd" if cell
||| F1 contained an odd number?
|||
||| Thanks

I nearly missed your reply as you'd top posted.

Sorry for the lacking subject

 

[Jono]

Thanks for the response, Andy.

Unfortunately, I receive the error below

#NAME?


I cannot get the ISODD function to function.


Andy B wrote:
|| Hi
||
|| Try:
|| =IF(ISODD(A2),"Odd","Even")
||
|| --
|| Andy.
||
||
|| ||| Hello,
|||
||| I have a spreadsheet of addresses. Following previous assistance in
||| this group, the sheet is sorted perfectly......nearly.
|||
||| The addresses are numerically sorted - 1 Anystreet, 2 Anystreet, 3
||| Anystreet etc. The house numbers are in separate cells from the
||| road name.
|||
||| What I would like to do is apply some conditional formatting - I
||| would like to embolden an entire row, should the house number be an
||| even number.
|||
||| Alternatively, if it's possible to sort all the odds together, and
||| all the evens together, I can apply the formatting manually.
|||
||| What would be the formula that would return the value "odd" if cell
||| F1 contained an odd number?
|||
||| Thanks

 

[Jono]

Working now, thanks - I had to install the "Analysis Toolpak" Add-in

Jono wrote:
|| Thanks for the response, Andy.
||
|| Unfortunately, I receive the error below
||
|| #NAME?
||
||
|| I cannot get the ISODD function to function.
||
||
|| Andy B wrote:
|||| Hi
||||
|||| Try:
|||| =IF(ISODD(A2),"Odd","Even")
||||
|||| --
|||| Andy.
||||
||||
|||| ||||| Hello,
|||||
||||| I have a spreadsheet of addresses. Following previous assistance
||||| in this group, the sheet is sorted perfectly......nearly.
|||||
||||| The addresses are numerically sorted - 1 Anystreet, 2 Anystreet, 3
||||| Anystreet etc. The house numbers are in separate cells from the
||||| road name.
|||||
||||| What I would like to do is apply some conditional formatting - I
||||| would like to embolden an entire row, should the house number be
||||| an even number.
|||||
||||| Alternatively, if it's possible to sort all the odds together, and
||||| all the evens together, I can apply the formatting manually.
|||||
||||| What would be the formula that would return the value "odd" if
||||| cell F1 contained an odd number?
|||||
||||| Thanks

 

[Don Guillett]

I nearly missed your reply as you'd top posted.
That's what we do around here.

 

[Jono]

I gathered as much

Don Guillett wrote:
||| I nearly missed your reply as you'd top posted.
|| That's what we do around here.
||
|| --
|| Don Guillett
|| SalesAid Software
|| (e-mail address removed)
|| ||| Don Guillett wrote:
||||| for the sake of the archives, please use meaningful subject lines
|||||
||||| --
||||| Don Guillett
||||| SalesAid Software
||||| (e-mail address removed)
||||| |||||| Hello,
||||||
|||||| I have a spreadsheet of addresses. Following previous assistance
|||||| in this group, the sheet is sorted perfectly......nearly.
||||||
|||||| The addresses are numerically sorted - 1 Anystreet, 2 Anystreet,
|||||| 3 Anystreet etc. The house numbers are in separate cells from the
|||||| road name.
||||||
|||||| What I would like to do is apply some conditional formatting - I
|||||| would like to embolden an entire row, should the house number be
|||||| an even number.
||||||
|||||| Alternatively, if it's possible to sort all the odds together,
|||||| and all the evens together, I can apply the formatting manually.
||||||
|||||| What would be the formula that would return the value "odd" if
|||||| cell F1 contained an odd number?
||||||
|||||| Thanks
|||
||| I nearly missed your reply as you'd top posted.
|||
||| Sorry for the lacking subject

 

[Dave Peterson]

Excellent response <vbg>.

(well, it made me laugh.)

I gathered as much

Don Guillett wrote:
||| I nearly missed your reply as you'd top posted.
|| That's what we do around here.
||

<<snipped>>