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

Question

Conditonal Formatting

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

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 wwhich I can achieve this without succh tedious work.

Of course, if there is no way, then I guuess the hard way will just haave to be endured...! :(

TIA for any help...

Explanation / Answer

Maybe this.

Select F2:Gxxx

Conditional forrmat,use forrmula

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