Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting of Cells with Multiple Cell Values | Excel Discussion (Misc queries) | |||
conditional formatting consecutive cells | Excel Worksheet Functions | |||
Conditional Formatting for multiple values | Excel Discussion (Misc queries) | |||
Conditional formatting on Consecutive cells | Excel Worksheet Functions | |||
Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions |