Conditional Formatting Help-highlights a single row

First Name that cell on the other tab through Formulas|Define Name or enter a name directly in the Name box to left of the formula bar...

Then select range in the initial sheet to affect and invoke Home|Conditional Formatting|New Rule

Select Use a formula to determine which cells to format

and enter formula like:

=AND(DataCell="Yes",$X1>$Y1,$X1<$Z1)

where DataCell is the name of the dropdown cell, X1, Y1 and Z1 are the cells to compare within row 1 (the top most row of your selection... change if necessary).