Hi,
I'm in need of extra brain power with this challenge.
I want to use conditional formatting to compare the name and the class to the master table
and highlight if the class does not match for that name.
I have used the following formulas
=AND(COUNTIF('MASTER'!$A$2:$A$264,A2)=1,Not(ISERROR(MATCH(B2,'MASTER'!$B$2:$B$264,0))))
**the above formula highlights all the classes red
=AND((A2='Master'!A2),(B2='Master'!B2))
**the above formula does NOT highlight the class in B2 but all the rest are highlight red
Name Class
Brad A
Carl D
Doug C
Eddie F
Frank A
Master
Name Class
Brad A
Carl E
Doug B
Eddie F
Frank A
Your suggestions and help would be greatly appreciated.
Thank you in advance,
Bev
I'm in need of extra brain power with this challenge.
I want to use conditional formatting to compare the name and the class to the master table
and highlight if the class does not match for that name.
I have used the following formulas
=AND(COUNTIF('MASTER'!$A$2:$A$264,A2)=1,Not(ISERROR(MATCH(B2,'MASTER'!$B$2:$B$264,0))))
**the above formula highlights all the classes red
=AND((A2='Master'!A2),(B2='Master'!B2))
**the above formula does NOT highlight the class in B2 but all the rest are highlight red
Name Class
Brad A
Carl D
Doug C
Eddie F
Frank A
Master
Name Class
Brad A
Carl E
Doug B
Eddie F
Frank A
Your suggestions and help would be greatly appreciated.
Thank you in advance,
Bev