Highlight cells where the last charcter in the cell is a blank

[Pat]

Hi All,

If anyone knows the answer to this one without putting themselves out,
I would be very grateful.

I have a load of entries in column A (A1:A2000) and some of the cells
contain a blank character at the end.

Just wondering if those cells with a blank character as the last
character can be highlighted by running a formula or macro?

Many thanks in advance,

Cheers,

Pat

 

[Fred Smith]

You want conditional formatting (in the Format menu).

Check for Right(a1,1)=" " and then format the cell however you want (eg,
background color).

Post back if you need more help.

Regards,
Fred.

 

[Pete_UK]

By "blank" character, do you mean a space or a non-breaking space
character (code 160) or some-such ?

Pete

 

[Pat]

Hi,

Yes. I mean just an actual space " "

I guess it might start something like IF(Right(a1,1)=" ", then format
the cell to colour "yellow")

Thanks again,

Cheers,

Pat

 

[Fred Smith]

That's exactly what conditional formatting does. Give it a try.

Regards
Fred

 

[Pete_UK]

Pat,

Highlight all the cells A1:A2000, then click on Format | Conditional
Formatting and in the panel that pops up choose Formula Is rather than
Cell Value Is in the first box. In the second box enter this formula:

=RIGHT(A1,1)=" "

then click on the Format button, slect the Patterns tab (for
background) then click on Yellow. Click OK twice to exit the CF
dialogue, then you should have what you want applied to all the
highlighted cells.

Hope this helps.

Pete