Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell references when inserting cells elsewhere | Excel Discussion (Misc queries) | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |