Strikethrough cells with same Values

**Zotius** · 03-09-2010, 12:35 AM

Hi I'm trying to strikethrough cells which have the same value in a certain row.

In the example, I have various columns labelled "A" to "I". There are different values in the cells. I want to strikethrough cells which have the same value but only in columns "F" & "G" and "E" & "H".

**rwgrietveld** · 03-09-2010, 04:13 AM

Select E7:H17

Add condition formatting formula: =COUNTIF($G7:$J7,G7)>1
and enable strikethough.

IMHO it would be better to use a color instead of a strikethrough as a strikethrough in a 4 canot be seen.

**Zotius** · 03-09-2010, 05:55 AM

Sorry I don't really get how you can enable strikethroughs on the Trues but not the Falses other than Selecting the trues by clicking one by one then enabling strikethrough. I do agree colouring is better but since my boss requires strikethroughs well so be it.