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