HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL
Hi all,
I want to highlight a row based on the contents of a single cell.
EG
K23 has "XX"
I want to highlight the whole of row 23.
It has to be based on that cell only as columns on either side also contain
"xx" and i dont want to inclued these in the calculation.
Any help would be much apprietated.
|