Resumen de Color-coding values
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.
