Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to highlight a row containing specific phrase?
For example I need to highlight all rows containing 'TODO' anywhere in the
text. I've tried conditional formating with formula condition '=FIND("TODO";)1' but failed. I'm looking for 2 answers: 1) how to represent the current cell reference in the formula. Is the simple omitting (as shown above) correct? 2) how to apply the format to the whole row, not just to the cell meeting the condition? Thank in advance for your help! --Josef |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink button to a specific cell in excel | Excel Discussion (Misc queries) | |||
How can I highlight every other group of data? | Excel Discussion (Misc queries) | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |