| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting, Multiple Criteria
First, please pardon my absolute inability to properly explain what I am
about to ask. I know next to nothing (or less) about programming. I am trying to find out if I can make one cell do conditional formatting, based on five different sets of criteria. Currently, it is set at the following (please forgive "layman's terms"): If F21 is between IU26 and IV26, then change cell and font to green. This works fine. What I need it to be able to do is perform the conditional formatting based on one of the following five sets of criteria: If F19 is between J29 and K29 and if F21 K31... or If F19 is between K29 and L29 and if F21 L31€¦ or If F19 is between L29 and M29 and if F21 N31€¦ or If F19 is between M29 and N29 and if F21 O31€¦ or If F19N29 and if F21 P31€¦ €¦ then change cell and font to green. Is this even possible?? And if so, how do I go about making it so? -- Lara |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting, Multiple Criteria
On Tue, 27 Jun 2006 09:33:02 -0700, Lara wrote:
First, please pardon my absolute inability to properly explain what I am about to ask. I know next to nothing (or less) about programming. I am trying to find out if I can make one cell do conditional formatting, based on five different sets of criteria. Currently, it is set at the following (please forgive "layman's terms"): If F21 is between IU26 and IV26, then change cell and font to green. This works fine. What I need it to be able to do is perform the conditional formatting based on one of the following five sets of criteria: If F19 is between J29 and K29 and if F21 K31... or If F19 is between K29 and L29 and if F21 L31¡K or If F19 is between L29 and M29 and if F21 N31¡K or If F19 is between M29 and N29 and if F21 O31¡K or If F19N29 and if F21 P31¡K ¡K then change cell and font to green. Is this even possible?? And if so, how do I go about making it so? It IS possible. You don't even have to user VBA, because you have only ONE conditional formatting. Just create a formula that will return "X" if data matches or "O" if not, and use this cell as source for conditional formatting. -- PL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting - multiple criteria | Excel Worksheet Functions | |||
| Conditional Formatting for multiple criteria | Excel Discussion (Misc queries) | |||
| Conditional Formatting with multiple criteria | Excel Discussion (Misc queries) | |||
| Conditional Formatting with multiple criteria | Excel Programming | |||
| Multiple Criteria for Conditional Formatting | Excel Worksheet Functions | |||
Hybrid Mode
