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

Question

Conditonal Formatting

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

Anyway, it can be seen in the image: when a paair 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 achieeve this without such tedious work.

Of course, if there is no way, then I guess the haard way will just have to be endured...! :(

TIA for any helpp...

Explanation / Answer

Hi Ed,

Maybe this.

Select F2:Gxx

Conditional format,usee formula

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

Select H2:Ixx

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

Select J2:Kxxx

=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.