Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Ok, so I inherited an excel workbook full of excel forms to modify. I am not the original author of the form. I cannot for the life of me figure out why it wont let me change the background color of certain cells.

The form has the cells colored where user input is required. I simply want to change this background color. I am using Excel 2007 on Windows XP, but this form was orginally created with an older version of excel.

Steps taken so far:

  • Worksheet is unlocked
  • Workbook is unlocked
  • cell is unlocked
  • any attempts to change the background color from (right click 'format cells' and ribbon controls). It looks like it changes it in the settings, but you say ok and it doesn't apply.
  • No VB code that affects the color of cells
  • Cannot not see any data validation that would even affect a cell color. (Maybe I am missing something?)

I do notice that once input is put the cell, the color of the cell will change to white. Is thier some data validation that can change cell color once content is inputed?

Any ideas?

share|improve this question

1 Answer 1

up vote 8 down vote accepted

Did you check for conditional formatting? It is harder to change.

Not sure where it is at in Excel 2007, but the mac version has it under:

Format => Conditional Formatting

Update: From the comments we have a way for Excel 2007:

Ah ha! I found a condition string for that cell. The condition formatting option is under the "Home" tab of the ribbon, not in data or formulas. – Troggy

share|improve this answer
    
Ah ha! I found a condition string for that cell. The condition formatting option is under the "Home" tab of the ribbon, not in data or formulas. Thank you. –  Troggy Sep 29 '09 at 22:09

Your Answer

 
discard

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.