Hi all,
I am trying to figure out how to set up conditional formatting in Google Docs for each row ONLY to check columns. So for example. I was able to do a formula:
=COUNTIF($E$1:$X$100, INDIRECT(ADDRESS(ROW(), COLUMN(), 4))) > 1
for overall table but is there a way to do a formula so it looks on individual row? So for example:
Row 1: A B C D E A A (formula should only highlight row 1 A A A)
Row 2: A B C D E E E (formula should only highlight row 2 E E E)
Thanks very much!
I am trying to figure out how to set up conditional formatting in Google Docs for each row ONLY to check columns. So for example. I was able to do a formula:
=COUNTIF($E$1:$X$100, INDIRECT(ADDRESS(ROW(), COLUMN(), 4))) > 1
for overall table but is there a way to do a formula so it looks on individual row? So for example:
Row 1: A B C D E A A (formula should only highlight row 1 A A A)
Row 2: A B C D E E E (formula should only highlight row 2 E E E)
Thanks very much!