HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL
So if K2 = "xx", highlight only row 2 and if K23="xx", highlight only row 23?
If so, select rows 2:32 and try this formula in your conditional formatting:
=SUMPRODUCT(--($K2:$M2="xx"))0
If you want rows 2:32 dependent on K23:M23 and not columns K:M of their
respective rows, try
=SUMPRODUCT(--($K$23:$M$23="xx"))0
"Chopper" wrote:
Thanks JMB,IT WORKED A TREAT.
Now i need to know if there is a way of applying this Formula to the whole
sheet.
EG
When there is "xx" in cell k23 or l23 or m23 then 23 is highlighted.
I want to do this from row 2 through to row 32.
Chopper
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.
|