Question: How do you create a heatmap in a table, such as this one, which is responsive to the values?

  1. map chart
  2. color scales (within conditional formatting)
  3. manual highlighting
  4. data bars (within conditional formatting)

Answer: The correct answer of the above question is Option B:color scales (within conditional formatting)