Strikethrough cells with same Values

[Zotius]

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]

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]

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.

[zbor]

Impress your boss.. Suggest him Double Underline instead of Strikethrough

Or single Underline and Strikethrough