Home > DeveloperSection > Forums > Conditional row color based on a cell value in Excel 2010
Manoj Bhatt
Manoj Bhatt

Total Post:154

Posted on    March-11-2013 1:02 AM

 MS Access MS Access 

 1 Reply(s)
 2126  View(s)
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.


Total Post:604

Posted on    March-11-2013 8:51 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick