I have tried using conditional formatting but it only colours the cells not the full rows.
=$G1="Word"
Select allOpen in new window