| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - comparison with another cell
Good tips. Thank you for the help!
"David Biddulph" wrote: You don't need =IF(...,FALSE,TRUE) =NOT(ISERROR(FIND("td",B5))) should do the job, or =ISNUMBER(FIND("td",B5)) or =ISNUMBER(SEARCH("td",B5)) if you want the search to be case insensitive which the OP wanted. -- David Biddulph "Sean Timmons" wrote in message ... Try: =IF(ISERROR(FIND("td",B5)),FALSE,TRUE) "Jezza" wrote: I'm trying to get a cell highlighted if its value contains the (alphabetic) value in another cell. I've got a rule in cell C16 of =B5 ="td" and this correctly highlights when C16 and C5 are both set to 'td'. But I want it to really to be 'contains' not '=' and then to be able to put in a string of values 'td, ps, jc' and so on. So C16 could be set to 'JC/PS' and would go red if C5 contained either 'JC' or 'PS'. . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional comparison of values. | Excel Worksheet Functions | |||
| Conditional Formatting across many cells with a mobile comparison | Excel Discussion (Misc queries) | |||
| Excel Conditional Formatting - Two Dates Comparison | Excel Discussion (Misc queries) | |||
| String Comparison & Conditional Formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
