| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - comparison with another cell
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
