I have a situation where I want to format a cell based on whether a different cell contains a certain word. Is that possible to do?
Cell A3 is the cell to conditionally format
Cell D3 is the source cell for the conditional format of A3
D3 will contain a free form sentence
I want A3 to change colour if D3 contains the text "waiting" somewhere in that sentence
I already have a conditional formatting rule applying to D3 that changes its colour if it contains the specific text "waiting" which works great, I just don't see how to apply that rule to another cell in the way I described.