I'm using Excel 2008 and would like to have a series of cells that may have a value by a calculation, or they may be empty. In the case where they are empty, I would like to be able to use the "Center Across Selection" feature. Normally for blank cells, I just use two sets of quote symbols so nothing is displayed, but in this case, I would like to center over that selection. Is there any way to do this?
If the context is useful, I am trying to highlight when periods occur in a project plan. For some efforts, there may be 12 month periods, 6 month periods, etc. In the below picture, I have conditional formatting working above the text to show the bounds of each 5 month period, and I have the number of the period in the first month of that period. I would like to change the text to "Period "&#. If I do this, a good portion of the text will be truncated, but if I could center across selection, the formatting would be improved.
<IMG SRC="http://www.schalliol.com/forums/excel/periods.png">
Any help is much appreciated!
If the context is useful, I am trying to highlight when periods occur in a project plan. For some efforts, there may be 12 month periods, 6 month periods, etc. In the below picture, I have conditional formatting working above the text to show the bounds of each 5 month period, and I have the number of the period in the first month of that period. I would like to change the text to "Period "&#. If I do this, a good portion of the text will be truncated, but if I could center across selection, the formatting would be improved.
<IMG SRC="http://www.schalliol.com/forums/excel/periods.png">
Any help is much appreciated!
