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.