|
» Color Unique Record in a Range in Excel 2007
CATEGORY: Excel Format |
VERSIONS: Microsoft Excel 2007 |
|
To color a unique record in a range, use Conditional Formatting: Option 1: 1. Select the range of cells (or select the entire column). 2. Select Home -> Conditional Formatting (in Styles Group) -> Highlight Cells Rules -> Duplicate Values. 3. Select Unique, and from Values with dropdown list select the format and click OK. Option 2: 1. Select the range of cells (or select the entire column). 2. Select Home -> Conditional Formatting (in Styles Group) -> New Rule. 3. Select Use a formula to determine which cells to format. 4. In Format values where this formula is true text box enter the following formula (ensure the Absolute and Relative references): =COUNTIF($A$1:A1,A1)=1 5. Click Format, and select the Patterns tab. 6. Select a color, and then click OK twice.  |
|
RATING:
VIEWS: 2092 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
