CONDITIONAL ROW COLOR BASED ON A CELL VALUE IN EXCEL 2010

Manoj Bhatt

Total Post:154

Points:1086
Posted by  Manoj Bhatt
 2189  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. AVADHESH PATEL

    Post:604

    Points:4228
    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!