| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using wildcards with logical (IF, AND) conditional formatting
I have two columns: A & B. Assume A contains a combinaton of numbers and
letters (e.g. 13.00.10i.022) and is formated as "General." Column B is a whole number between 1 and 3. I would like to create a Conditional Format formula that says "IF B=1 AND A does NOT begin with the number "12", then color that ROW red. Continuing, "IF B=1 AND A DOES begin with the number "12," then do nothing (no color format). How do I do this? Thanks ! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use of wildcards in conditional formatting | Excel Worksheet Functions | |||
| Conditional Formatting: Logical AND fails to work with INDIRECT(.. | Excel Worksheet Functions | |||
| Wildcards with Conditional Formatting? | Excel Discussion (Misc queries) | |||
| Excel Conditional Formatting color multiple cells for 1 logical | Excel Worksheet Functions | |||
| Can logical operators be used within Conditional Formatting? | Excel Discussion (Misc queries) | |||
Threaded Mode
