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

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.

"Pat" wrote in message
...
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

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

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

Regards
Fred

"Pat" wrote in message
...
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

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

On Feb 27, 12:45*pm, Pat wrote:
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

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

Pete

On Feb 27, 11:47*am, Pat wrote:
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