| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
unions, intersections or array constants
Thanks for the info and all your help guys.
"T. Valko" wrote: if your user enters MarMay in AK2 I wonder what the odds of that happening are? We don't even know if these are user entered, they may be formula results. -- Biff Microsoft Excel MVP "Rick Rothstein" wrote in message ... One thing to watch out for in Biff's formulas... if your entries are not well controlled, there is a remote possibility of getting false hits. For example, if your user enters MarMay in AK2, the that cell will turn blue. As structured, if your user types in any substring from "JANMARMAYJULSEPNOV" (such as the MarMay I used) or from "FEBAPRJUNAUGOCTDEC", then those substrings will be considered a hit. -- Rick (MVP - Excel) "T. Valko" wrote in message ... Use the Formula Is option and use these formulas: For Blue: =AND($AK$2<"",SEARCH($AK$2,"JANMARMAYJULSEPNOV")) For Green: =AND($AK$2<"",SEARCH($AK$2,"FEBAPRJUNAUGOCTDEC")) -- Biff Microsoft Excel MVP "Loadmaster" wrote in message ... I am trying to make a conditional formatting formula in cell A3 that goes something like this =$AK$2=JAN, MAR, MAY, JUL, SEP, NOV to format Blue and =$AK$2=FEB, APR, JUN, AUG, OCT, DEC to format Green. It keeps coming up with "You may not use unions, intersections or array constants for conditional formatting criteria. Cell A3 and cell AK2 both have array fomulas. Is there a solution to make this work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula constants? | Excel Worksheet Functions | |||
| Constants in Excel | Excel Discussion (Misc queries) | |||
| how to find intersections points of lines in charts | Charts and Charting in Excel | |||
| Intersections | Excel Discussion (Misc queries) | |||
| constants | Excel Discussion (Misc queries) | |||
Threaded Mode
