Transcript Excel Discovery: How to change the row color based on a

Excel Discovery:
How to change the row color
based on a cell's value in Excel
Na (Chelsea) Yang
Net Id :ny79
Presented on Oct 27 2014
Say, you have a table of your company orders like this and you may want to shade the rows
in different colors based on the cell value in the Qty. column to see the most important
orders at a glance. This can be easily done using Excel Conditional Formatting.
1. Start with selecting the cells the background color of which you want to change.
2. Create a new formatting rule by clicking Conditional Formatting > New Rule... on
the Home tab.
3. In the "New Formatting Rule" dialog window that opens, choose the option "Use a formula
to determine which cells to format" and enter the following formula in the "Format values
where this formula is true" field:=$C2>4
4. Click the "Format..." button and switch to Fill tab to choose the background color. If the
default colors do not suffice, click the "More Colors..." button to pick the one to your liking,
and then click OK twice.
4. The preview of your formatting rule will look similar to this
5. If this is how you wanted it and you are happy with the color, click OK to see your new
formatting in effect.
Now, if the value in the Qty. column is greater than 4, the entire rows in your Excel table will
turn blue.