Coloring complete Row based on values from Columns
excel, excel-formula, vba
Solution
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
Problem
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: - DELIVERED (to Green) - REJECTED (to Red) - WIP (to Orange).