Rather than highlighting only the status cell, you might want to highlight the entire row. To review the rules, go to Home, Conditional Formatting, Manage Rules. Repeat steps 2 through 6 for each of the four remaining colors, changing the 1 in step 3 to the other values. After choosing a color, click OK in each of the three open dialog boxes in order to return to Excel.ħ. But if none of those colors are the exact right shade, you can use the Custom tab to choose from 16.7 million colors.Ħ. This offers 163 colors, including many shades of popular colors such as red, orange, yellow, blue, and green. For a reliable palette of colors, click More Colors.
The 60 available colors have changed with each version of Excel and will change based on the theme used for the document. But to change the fill color of the cell, go to the Fill tab.ĥ. You could use this tab to change the color of the numbers in the cell. The Format Cells dialog opens on the Font tab. Open the dropdown and choose Custom Format…Ĥ. In the Equal To dialog box, type a 1 in the left box. On the Home tab, select Conditional Formatting, Highlight Cells Rules, Equal To…ģ.
Select the cells with the status codes.Ģ. Here are the steps to get the results shown:ġ. He was also very specific about which shades of blue and green needed to be used. Items with a status of 1 should be green, 2 should be blue, 3 yellow, 4 orange, and 5 red.
#EXCEL 2016 REVIEW MR EXCEL CODE#
The attendee had a worksheet with a status code in column D that contains possible values of 1 through 5.