Row Conditional Formatting (Excel 2003)

[hreal34]

On the attached worksheet, I have rows of "Teams" that undergo 3 Games (starting with Game 1 and working right). Each game is divided into an "Open Time" and a "Close Time". I would like to conditionally format the worksheet in that the row is highlighted red up to where the Open Time is entered, and the row is highlighted blue up to where the Close Time is finally entered. I have manually formatted my worksheet in order to better show what I'm looking for.

In previous attempts my formatting only applied to the current cell once I entered values in the Game 2 and 3 columns.

I realize this is an Excel 2007 file, but the actual file will be managed via Excel 2003.

[grizzly6969]

unable to open your link to your file ---- just attach a sample file by going advanced

[FDibbins]

See if the attached gives you what you want?

[hreal34]

Sorry for the belated response, but yes that's exactly what I wanted.

Marked as solved.