I have a value in D1 (which is constantly/automatically changing), If this value in D1 matches, say, E5, then I want the row to change colour to Orange, permanently.
Because D1 is changing, the cell does not seem to stay highlighted - is there anyway round this.
Also, I would like the whole row (from A5 to L5) to be highlighted, but this does not seem to work, eventhough I select all rows when setting the conditional format.
Because D1 is changing, the cell does not seem to stay highlighted - is there anyway round this.
Also, I would like the whole row (from A5 to L5) to be highlighted, but this does not seem to work, eventhough I select all rows when setting the conditional format.