Color-coding values

• Autores: Bill Jelen
• Localización: Strategic Finance, ISSN-e 1524-833X, Vol. 98, Nº. 2, 2016, págs. 82-83
• Idioma: inglés
• Texto completo no disponible (Saber más ...)
• Resumen

  • After choosing a color, click OK in each of the three open dialog boxes in order to return to Excel. 7. The reference to row 4 needs to be relative with no dollar sign. [...]for the data set in Figure 1, the formula of =$D4=1 would be used to find items that should be green. Using a color scale, the numbers are assigned various shades of red, yellow, and green based on the number selected.