시작하기무료로 시작하기

Formatting an entire row

Let's put what you just learned into action.

This sales report is not unlike the others. The difference here is that this sales report contains your own sales.

Of course, you want to honk your horn by highlighting the entire line whenever you had a sale, right?

If you only highlighted the cells from one column, readers of this report may miss how great you are.

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

Google Sheets에서 조건부 서식

강의 보기

연습 안내

  • Add a conditional formatting rule that uses a custom formula to highlight all sales by Morgan with the Default green background.
    • The range in the "Apply to range" box should be the entire range that you will be highlighting, not just the column with the names. Therefore, the range should be A2:F24.

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

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

연습 시작