Conditional formatting
On Dec 11, 11:21*am, "Gilbert DE CEULAER"
wrote:
Is there any possibility to conditionally center (or shift right) cell
contents ?
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.
|