엑셀 조건부 서식 수식 규칙

수식을 사용하여 서식을 지정할 셀 결정
다음 수식이 참인 값의 서식 지정
=IF($H$3<2,(OR(WEEKDAY(AG4)=1,WEEKDAY(AG4)=7)))
--> gray

=AND(AL$4>=$G5,AL$4<$G5+($H5-$G5+1)*$J5%)
-->black

=AND(AL$4>=$G5+($H5-$G5+1)*$J5%,AL$4<=$H5)
-->sprite light blue

=AND(AF$4>=$G5,AF$4<$G5+($H5-$G5+1)*$J5%)
---> black

=AND(O$4>=$G24,O$4<$G24+($H24-$G24+1)*$J24%)
--> black