Conditional formatting not updating 2016

Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003.

If you are using a later version (Excel 2007 or later), this tip may not work for you.

I can do on a cell-by-cell basis, but trying to use formulas/selecting a range to apply this to, it always ends up coloring the cell based on the first example only.

Right click and select Format Cells and select General.4. Here's today's situation: I want to color cells that already have values in them.

The remaining steps must be done individually for each cell that was just changed to General formatting;a. The values have nothing to do with the formatting, but the value in an adjacent cell does.

In the case where formulas simply point to other cells (within the same sheet, or even on other tabs), there is a simple trick that will engage the already established Conditional formatting conditions. Select all cells that were copied-to that currently are not working.2. So much else with Excel is intuitive, but not this.

Verify that the formulas are correct for each cell.3. Formatting should begin working immediate for the cell just completed. Whenever I need to copy/paste conditional formatting, I end up looking all over the internet to try and remember exactly HOW I did it the last time.

If you want to copy conditional formatting from one cell to another, you can do so by simply copying the cell and pasting it (or its format) to another cell.

If you want to copy a conditional format to a range of cells (and only the conditional format), the easiest way to do so is by following these general steps: Excel Tips is your source for cost-effective Microsoft Excel training.

For a version of this tip written specifically for later versions of Excel, click here: Copying Conditional Formatting.

In Excel, conditional formatting is considered part of the regular formatting of a cell.

This tip (2797) applies to Microsoft Excel 97, 2000, 2002, and 2003.

You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Copying Conditional Formatting.


  1. I’m also not gonna joke about it or try to disrespect him and try to act like he didn’t mean the world to me and still doesn’t mean the world to me.

  2. One of the world’s largest energy companies – a Fortune 100 leader in global oil, gas and chemical markets – turned a potential business disruption into a new opportunity to drive efficiency and innovation by providing 9,000+ worldwide employees with easy access to a major catalog publication via a single online platform.

  3. Access to the Review Analysis, Update Timeline, and Internationalization Analysis modules are available for Enterprise App Intelligence users.

  4. You can browse the user profiles for free, and send messages to other prospective can partners using their internal messaging system.

  5. We also stock a large range of these specialist interests Bondage, latex, fetish, stockings, high heels, female domination and BDSM.

  6. He’s an American, a lawyer, divorced twice (he thought he was bisexual, but finally came out gay and wouldn’t have anything more to do with women), and have been told that he has Richard Gere looks. We met when I was still living in Manila and he was visiting for a conference. But like Chris leaving Kim, he left too – only, he came back a year later. Bago matulog, nakatapal na ang moisturizer sa mukha ko. I know, my nickname indicates otherwise, but aside from the risk of being exposed to the rest of the world–especially on the web–I have no problem showing my “baby anaconda” to other guys who are simply horny peeping toms.

Comments are closed.