<div style="text-align:left;"><img src="http://thimg.todayhumor.co.kr/upfile/201901/1547401255db0328061584457a98cd14fc79a96bc0__mn720361__w624__h265__f27557__Ym201901.jpg" width="624" height="265" alt="K-1361.jpg" style="border:none;" filesize="27557"></div><br><div> <h1 style="margin:0px;padding:0px;font-size:12px;font-weight:normal;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;">[일자]셀(B3:B14)에 데이터를 입력하면, 해당 [비고]셀에만 항상 ‘현잔고’ 라는 문자가 표시되면서, 동시에 셀 바탕색이 노란색으로 채워지도록 할 것.</h1> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;"><b>+</b></p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;"><b>잔액 셀에는 조건 함수식</b></p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;"><b>비고 셀에는 조건 함수식 조건부 서식 지정</b></p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;">이 조건입니다. </p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;"> </p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;">1.</p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;">제가 추론한것은 일자 MAX값일때 비고에 조건부서식 채우기를 노란색을 넣는것 까진 하겠는데</p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;">현자고를 나타내는 법을 모르겠습니다.</p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;">알려주세요.</p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;"> </p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;">2. 잔액 셀 조건 함수식이란것을 어떻게 나타내야하나요?</p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;"> </p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;"> </p> <p style="margin:0px;color:#404040;font-family:'Apple SD Gothic Neo', AppleGothic, Roboto, Gulim, Dotum, 'Noto Sans KR', sans-serif;">컴활1급 공부하는데 2시간넘게 고민했는데 모르겠습니다.</p></div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.