Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have some calculated columns in an Excel (2007) table. I'd like to distinguish them visually from the user-input columns in some way, but without losing the nifty automatic row banding. It looks like I can create a "table style", but only the first and last columns can get separate formatting. Is there any way to format arbitrary columns (or at least the last n columns instead of just the last one)?

share|improve this question

You can format columns to unlock cells which are user-input, and then set conditional formatting for columns in your table specifying the formula condition =CELL("protect", ) as condition. Or you can set the following udf:

Function IsFormula(cell)
  IsFormula = cell.HasFormula
End Function

and then set an analogous conditional formatting.

share|improve this answer
Thanks for the answer. Wouldn't conditional formatting lose me the rest of the table formatting though? Specifically the row banding? – jtolle Nov 5 '10 at 14:52
Yes, conditional formatting overwrites other formatting properties. It could not be different. You have to think a conditional formatting that is compatible with row banding. For example, a row banding with slight different colors than the other ones, or with different colors for text. About conditional formatting for row banding you can see – Toc Nov 5 '10 at 18:05
Try to set the color of cells in the columns using the conditional formatting. I tried it and you don't use the banding. – jhamu Nov 10 '10 at 14:22

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.