conditional formatting-Formatting selected rows
- Thread starter bines53
- Start date
Nightlytic
Member
Column G now has conditional formatting, the cells go red if they anywhere contain the corresponding value from A, modify the formula for whatever result you need.
Hi @ Nightlytic ,
I re-upload the file, with the required ROWS, and column A, the data are dynamic, and changing periodically,
Thank you !
DAVID
I re-upload the file, with the required ROWS, and column A, the data are dynamic, and changing periodically,
Thank you !
DAVID
Nightlytic
Member
Sorry David but what is the condition you are looking for? Cell G3 contains 2 which is on the list in column A, and you marked that black, Cell G4 contains 2 as well, but you marked it red?
Are you trying to count how many values match, or what is the logic?
Are you trying to count how many values match, or what is the logic?
Hi @ Nightlytic ,
I need to find only 17 rows, as shown in column A, the values in irrelevant cells.
Thank you !
DAVID
I need to find only 17 rows, as shown in column A, the values in irrelevant cells.
Thank you !
DAVID
John Jairo V
Well-Known Member
Hi, to all!
Just noting that CF not need error control. You can just use:
=MATCH(ROWS($G$3:$G3),$A$3:$A$19,0)
Blessings!
Just noting that CF not need error control. You can just use:
=MATCH(ROWS($G$3:$G3),$A$3:$A$19,0)
Blessings!
Khalid NGO
Excel Ninja
Hi to all,
One more:
=COUNTIF($A$3:$A$19,ROW(A1))
Regards,
One more:
=COUNTIF($A$3:$A$19,ROW(A1))
Regards,
John Jairo V
Well-Known Member
I prefer this method:
=COUNTIF($A$3:$A$19,ROWS($G$3:$G3))
Because if you insert rows or delete Column A the formula you propose doesn't work. If you take care about the cell you start, you avoid this problem. Blessings!