Excel Highlight Row Based on Cell Text

Excel Highlight Row Based on Cell Text

Excel Highlight Row Based on Cell Text

Business Scenario: We have a list of sales done in the fruit store. As per the requirement we need to highlight entire list row based on below criteria.

  • Highlight row in light green color if the Payment is Paid
  • Highlight row in light red if Payment is Failed.
  • Highlight row in light yellow if Payment is COD.
  • Highlight row in light grey if Payment is Refund.

Below is the dummy data in our excel file

As per the requirement we need to highlight as show in below image

 

 

For this we need to use coditional formatting. 

0 Comments
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first

share