Conditional Formatting an Entire Row, Based on Results in a Single Row

I have a data set of 100 files with 6 columns of variables. I want any row with the text "50-100 Days" to be highlighted in red. I can make the cell be highlighted, but I cant seem to figure out how to have the entire row be highlighted based on that one column. I am using Excel 2007.


Assistance would be much appreciated.

Thank you,

Nick

Select all the rows and use a formula like this, changing the cell reference as required.

=$D2="50-100 Days"

This assumes you want to base the formatting on column D and that the data starts in row 2.

The $ before D anchors the reference to that column, without it the formula would change in the other columns.

This worked great!! Thank you so much for your time and expertise.