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).
vba excel excel-formula
Edit
Report