I would like to highlight the whole row if conditional format is true in some cells for example:
Contained text: Sent Back
But some cells contain other datas too, for example: Sent Back dgsdaaslkg
Conditional format (the second condition->only for cells that contain)
The text contained for example D4, K20;L4000... end so on
The Conditional format is working on the worksheet, but I can not implement the condition for the whole row if one cell compliance to the condition.
Please Help me!
Thank you!
Contained text: Sent Back
But some cells contain other datas too, for example: Sent Back dgsdaaslkg
Conditional format (the second condition->only for cells that contain)
The text contained for example D4, K20;L4000... end so on
The Conditional format is working on the worksheet, but I can not implement the condition for the whole row if one cell compliance to the condition.
Please Help me!
Thank you!