HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL
Select all of row 23 (or however much of it you want highlighted
Format/Conditional formatting
Formula is
=$K$23="XX"
then select your format preference.
"Chopper" wrote:
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.
|