開始使用免費開始

Highlighting cells between a range

In this next task, you will create a rule that will highlight cells in the Close column if the value in the cell falls between a certain range.

本練習屬於課程

Google Sheets 的資料視覺化

檢視課程

練習說明

  • Highlight the Close data in F17:F26 and create a rule that bolds the text and sets the font color to 'blue' when the value is between 0.040 and 0.050.
  • Make sure the background color in the conditional formatting is set to 'white'.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習