If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
flag cells
I am working with zip codes and when certain (around 25) zipcodes are
entered, I need for the format of the cell to change colors. How can I go about doing this? |
#2
|
|||
|
|||
flag cells
Try this:
Put the 25 zip codes in a vertical list on another sheet in the workbook. Name that list: Select the 25 cells, then In the Name box (Just above the Col_A heading) enter: LU_ZipList Press [Enter] Now, select an input cell (I'll use A2) FormatConditional Formatting Select: "Formula Is" from the dropdown Formula: =ISNUMBER(MATCH(A2,LU_ZipList,0)) (Note: No dollar signs in the A2 reference) Click the [Format] button and set the display to show for zips on the list Click the [OK] button Now copy A2 down as far as you need. When you enter a Zip Code that is on the list....your conditional format will display. Does that help? *********** Regards, Ron "M.A." wrote: I am working with zip codes and when certain (around 25) zipcodes are entered, I need for the format of the cell to change colors. How can I go about doing this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I automate flag color? | RV | General Discussion | 0 | October 4th, 2005 08:45 AM |
trying to create an (almost) circular formula between cells and data validated cells with lists | KR | Worksheet Functions | 0 | May 12th, 2005 07:21 PM |
Unlocking Cells when a worksheet is protected... | racmb1975 | General Discussion | 2 | May 3rd, 2005 08:57 PM |
Linked cells | Seaside Mark | General Discussion | 4 | September 28th, 2004 12:29 AM |
Cannot lock/protect Merge and Center Cells | Tammy | General Discussion | 7 | July 9th, 2004 05:51 PM |