시작하기무료로 시작하기

Dates

Let's bring it all together to practice what you learned in chapter one by looking at several different attributes in the exercise. This is another example of sales transactions. Each row contains different information for each sale including date, dollar amount, sales rep, and item weight.

There are a number of pieces of information that we are interested in and want to highlight in this sheet. You can use your knowledge of greater than / less than to show the items with the prices over $500. We also want to highlight the heavier item weights to indicate which items need special handling.

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

Google Sheets에서 조건부 서식

강의 보기

연습 안내

  • Add a conditional formatting rule to highlight item prices in C2:C16 that are over $500 in the Default green color.

  • Add a conditional formatting rule to D2:D16, using the color scale "White to red" option.

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

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

연습 시작