(A) Use the bucket to manually change each cell
(B) Use the =colorif formula
(C) Print the sheet and use a highlighter
(D) Use conditional formatting
One (efficient) way to format data on a sheet using color is by using conditional formatting.
This question is a part of the Unit 5 Review of the Google for Education Advanced Training. You can find answers to all the Unit 5 Review questions in our Google for Education Advanced Training Answers page.