mcescher answered this in your earlier post.

"msescher" wrote:
You could do it with a hidden column.

Assuming column A is your data, and you want to shift anything over
25. Insert a column at B and use this formula:
=If(a125," " & a1, a1)

The string is just five spaces, adjust to your own needs.

Hope this helps,
Chris M.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Gilbert DE CEULAER" wrote:

Is there any possibility to conditionally center (or shift right) cell
contents ?