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
|