시작하기무료로 시작하기

Conditional formatting

Now that we've been introduced to the concept of conditional formatting, let's put it to use.

In the following table, you'll find quarterly sales data from the sales reps at your company.

You need to highlight the "Yes"s for the sales reps that met their goals.

이 연습은 강의의 일부입니다

Google Sheets에서 조건부 서식

강의 보기

연습 안내

  • Select the range by higlighting C2 to C14.
  • Go to Format, choose Conditional Formatting, click the drop down under Format cells if, and choose the "Text contains" option.
  • Type Yes into the box and leave the Default Formatting style of a green background.

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작