Conditional formatting won't update until cell is selected: Excel

  • Thread starter Thread starter TWC
  • Start date Start date
T

TWC

This applies to Excel 2007.

I have a column full of values that have conditional formatting that says,
if the value in this cell matches the value in cell $C$1, turn yellow. If I
type a value in C1 that matches cell A6, for example, it won't turn yellow
until I select cell A6, or edit data elsewhere in row 6.
 
Yes, I do have it set to automatically calculate cells. However, remember I
am using Excel 2007, so there is no "tools - options" menu as you say.

Apparently since Excel 07 has over 1 million rows and tens of thousands of
columns, it doesn't automatically calculate every cell, but instead
intelligently looks for formulas' precedents and dependents and updates only
those. Do you think the fact that my numbers are static values has anything
to do with why they won't update?
 
It has always intelligently determined what needs recalculating, that is why
it is (generally) fast.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 conditional formatting bug? 2
How do I set conditional formatting relative to another cell -XL20 2
conditional formating for the whole row, based on one cell value 2
Conditional Formatting by percent range 2
conditional formatting help please 2
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Conditional Formatting 5
Conditional formating - for blank cells 5

Back
Top