A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

flag cells



 
 
Thread Tools Display Modes
  #1  
Old December 5th, 2005, 09:44 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default 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  
Old December 5th, 2005, 09:57 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.