Selected Answer
Graham
Your existing Conditional Formatting rule (for column H) reads:
- Format only cells that contain
- Specific Text containing
- TP
This actually equates to a formula (for H1) of:
=NOT(ISERROR(SEARCH("TP",H1)))
In the attached file, I've changed the Rule Type to Change to Use a formula... and made the formula read:
=NOT(ISERROR(SEARCH("TP",$H1)))
where the $ fixes the column.
After clicking OK, I then (carefully) changed "Applies to" from =$H:$H to
=$H:$H, $J:$J
then pressed OK.
Now existing cells in J have the same green formatting as TP entries in H and if you make a cell in H contain the text TP, the cell in J of that row also gets the same formatting.
Hope this helps.