| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format With Wildcard
Hubisan,
This looks like it will work, but it give error message "The formula you typed contains an error." and highlights "P" in the formula. Thanks for your help. Pam "Hubisan" wrote in message ... Use this formula as conditional formatting: =AND(RIGHT(H11,1)<"P";G11=5) And btw, u can use wildcards whith some formulas like "=Search("*P",H11)" Hubisan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional Formatting cell wildcard | Excel Worksheet Functions | |||
| Conditional formula containing text and wildcard | Excel Worksheet Functions | |||
| Wildcard for any number in conditional formula | Excel Discussion (Misc queries) | |||
| Wildcard for Conditional Sum Wizard statement. | Excel Worksheet Functions | |||
| Excel Conditional Formating using 'like' or wildcard logicals | Excel Worksheet Functions | |||
![Pam[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
