#### Yodelayheewho

##### Member

I need to apply a conditional format based on the number of periods/decimals in the number. Once I figure out the formula, I know how to set up the formatting for the indents. It's the formula that is puzzling me. Is there a formula that will count the number of periods/decimals? I've tried several things and nothing's working.

1.1 = indent 1 place

1.1.1 = indent 2 places

1.1.1.1 = indent 3 places

I was able to figure out the formula for 1.1 = indent 1 place. I have: =MOD($A1,1)>0. Works great, but need a formula for the numbers with more than one decimal.

I can not use VBA.

Thank you!