View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Format cells with 0 as the tenth digit

On Sat, 7 Feb 2009 11:06:02 -0800, PointerMan
wrote:

I meant to say that I want to do a conditional format on the selected cells
(highlight them some color).

"PointerMan" wrote:

How do I format cells that have a zero for the tenth digit?


Use a formula for the conditional formatting:

=AND(LEN(TRUNC(A1))=10,RIGHT(TRUNC(A1),1)="0")

--ron