Conditonal Formatting My problem...? Maybe I am just lazy... Anyway, it can be s

Question

Conditonal Formatting

My problem...? Maybe I am just lazy...

Anyway, it can be seen in the image: when a pair of entries on the right (FG thro' JK) equals the pair on the left (C & D) they are highlighted in Black Bold. The only means of achieving this using "Duplicate" in Conditional Formatting that I can see, is to apply it individually to each pair in turn. That is over 120 entries, each with multiple actions.

Does anyone know of a means by which I can achieve this without such tedious work.

Explanation / Answer

Select F2:Gxx

Conditional format,use formula

=AND($C2=$F2,$D2=$G2)

Select H2:Ixx

=AND($C2=$H2,$D2=$I2)

Select J2:Kxx

=AND($C2=$J2,$D2=$K2)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.