Conditional Formatting Duplicate cell in a row only

demodren

Board Regular
Joined
Aug 20, 2010
Messages
106
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!
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,814
Office Version
365
Platform
Windows
No idea about Goggle, but this works in Xl
=COUNTIF($E1:$X1,E1) > 1
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,814
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,839
Messages
5,446,800
Members
405,415
Latest member
Noodnutt

This Week's Hot Topics

Top