Menu
I need to color the complete Excel row based upon the value of a cell in column.
I have three columns (Item, Price and Status) and want to color the row if the Status value is:
741
In the formula field, enter the following formula: =$C2=”Bob” Click the 'Format' button. In the dialog box that opens, set the color in which you want the row to get highlighted. Click OK.
Conditional Formatting is a feature in Excel that allows us to change the format of cells based on a set of rules or conditions. Conditional formatting can be applied to a set of selected cells, including an entire row.
You can use (non-VBA) conditional formatting for this
If your Status column was in column C then - having selected all the rows in the area of interest - you can use rules such as this to format the entire row based on the column C entries
=$C1="REJECTED" and pick Red=$C1="WIP" and pick Orange etc
Change your column reference to suit
The sample below is from Excel 2010
{NB: Change your text case if necessary}
See Debra Dalgleish's site for more detail
122
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
