시작하기무료로 시작하기

Weight range

You company is trying to allocate its shipping charges more fairly amongst its online customers.

As shipping costs can be reasonably estimated using weights, you decide to analyze the weights of your items. Since you want to look at all of the items instead of just pointing out outliers, let's use a color scale to apply formatting to all of the cells.

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

Google Sheets에서 조건부 서식

강의 보기

연습 안내

  • Highlight the range of C2 to C16, and use the Color scale option, which can be found at the top of the conditional formatting window.
  • Use the formatting style called "Green to white to red" that is on the bottom left of the nine default choices.

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

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

연습 시작