forum

Home / DeveloperSection / Forums / Conditional row color based on a cell value in Excel 2010

Ask Question

Conditional row color based on a cell value in Excel 2010

Manoj Bhatt369111-Mar-2013

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.

ms accessms access 
Updated on 11-Mar-2013
Manoj Bhatt

Manoj Bhatt

Follow

Can you answer this question?

Answer

1 Answers

AVADHESH PATEL

AVADHESH PATEL

11-Mar-2013
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.

Liked By