Conditional row color based on a cell value in Excel 2010

Total Post:154

Points:1086

 2812  View(s)
Ratings:
Rate this:

Hi Everyone!

How I set row color as per condition based.
For example user maintains excel sheet of student list based on pass and fail. User wants to set passed student’s row

color become green when he entered status as pass and on fail set row color as red.

Thanks in advance.

  1. Re: Conditional row color based on a cell value in Excel 2010

    Hi Manoj!


    Excel conditional formatting row color steps are given below

    Excel conditional formatting row color 

    1. Select your excel sheet.
    2. Now select “Conditional Formatting” tag from “Home” menu then select “New Rule…” option.
    3. Select “Use a formula to determine which cells to format” option for apply custom formula.
    4. Enter =$B1=”pass” into open popup window.
    5. Set row color and styles using “Format” button.
    6. Press "OK" button and see effect into your excel sheet.

      Modified On Mar-29-2018 11:16:29 PM

Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.