LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Conditional formatting with multiple, non-consecutive values??

Hi, I'm surprised that I can't find this matter addressed in any user guides
since I'm sure I'm not the first person to want to do this.

Okay, I'm sure it's easy and I'll feel dumb when someone explains it: I
want to do conditional formatting for multiple, non-consecutive values. For
instance, I want to conditionally format any cells that contain the numbers
4, 8, 13 and 25. How do I do that? Excel alwys seems to want to only
conditionally format a range or a top percentile or things that fit in
formulas.

And, once I do this, how can I make this an easy function each time?
Specifically, I receive Excel tables from time to time with mailing lists. I
don't want to send mail to certain zip codes. So, I want to be able to
conditionally format the new excel tabls I receive against a standard list of
zip codes I want to exclude. I guess ultimately, I'd like to make a macro.

Thanks for any help anyone can provide.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting of Cells with Multiple Cell Values BDankas Excel Discussion (Misc queries) 4 September 6th 07 07:06 PM
conditional formatting consecutive cells chris Excel Worksheet Functions 7 May 9th 07 09:41 PM
Conditional Formatting for multiple values Daniinboston Excel Discussion (Misc queries) 1 August 3rd 06 05:36 PM
Conditional formatting on Consecutive cells welshobit Excel Worksheet Functions 4 June 20th 06 03:58 PM
Return Summed Count of Multiple Consecutive Numeric Values Sam via OfficeKB.com Excel Worksheet Functions 4 April 10th 06 10:35 PM


All times are GMT +1. The time now is 02:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"