Conditional Formatting Question?

Hi all,

New to this forum and hoping that someone will have an idea as to what is going on with this conditional formatting issue?

I have a row of data in Excel 2013 that is roughly as follows :

Cell A2 - Date || B2 - Status || C2 - Description || D2 - Estimate Time || E2 - Comments

Cell B2 is a pick list of statuses --> Open || In Progress || Closed

The conditional rule I want to create is one where if B2 = 'Closed', format the text of the entire row (cell A2 to E2) to turn light blue.

I was successful in doing this --> basically highlighted A2 to E2; conditional formatting; new rule; use formula; $B$2 = "Closed"; format text color blue.

When I do this, now when cell B2 = Closed, the line turns blue.


The issue is I want this condition to apply to row 3, 4, 5, 6, 7 etc ... basically a multi-row list.

I highlight the cells (A2 ~ E2) and then grab the bottom right corner of E2 and drag down 5 rows (creating row for A3 / A4 / A5 / A6 / A7).

The issue is when I set B3 to Closed, nothing happens; likewise for B4 or B5 etc ...

When I set B2 to Closed, it changes itself and all the rows below to light blue.

This used to work in earlier versions of Excel, but I can not see to get this working in 2013.

Any thoughts (ideally without creating a formula for each row).

Thank you for your help!

Dan.

FDibbins,

Thank you for the reply!

Issue resolved immediately

Dan.