Thread: Highlight cells where the last charcter in the cell is a blank
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat[_4_] Pat[_4_] is offline
external usenet poster
  
Posts: 6
Default Highlight cells where the last charcter in the cell is a blank
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
Reply With QuoteReply With Quote