수업일 조건부서식

B열이 공란("")이 아니며

2행에 있는 수업요일과 같은 요일에 음영

3행에 있는 수업요일과 같은 요일에 음영

...

5행에 있는 수업요일과 같은 요일에 음영

=AND($B7<>"",WEEKDAY($B7)=IF(LEFT(C$2,1)="월",2,IF(LEFT(C$2,1)="화",3,IF(LEFT(C$2,1)="수",4,IF(LEFT(C$2,1)="목",5,IF(LEFT(C$2,1)="금",6,""))))))

=AND($B7<>"",WEEKDAY($B7)=IF(LEFT(C$3,1)="월",2,IF(LEFT(C$3,1)="화",3,IF(LEFT(C$3,1)="수",4,IF(LEFT(C$3,1)="목",5,IF(LEFT(C$3,1)="금",6,""))))))

=AND($B7<>"",WEEKDAY($B7)=IF(LEFT(C$4,1)="월",2,IF(LEFT(C$4,1)="화",3,IF(LEFT(C$4,1)="수",4,IF(LEFT(C$4,1)="목",5,IF(LEFT(C$4,1)="금",6,""))))))

=AND($B7<>"",WEEKDAY($B7)=IF(LEFT(C$5,1)="월",2,IF(LEFT(C$5,1)="화",3,IF(LEFT(C$5,1)="수",4,IF(LEFT(C$5,1)="목",5,IF(LEFT(C$5,1)="금",6,""))))))