View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mcescher mcescher is offline
external usenet poster
 
Posts: 24
Default 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.