You could use Conditional Formatting.
By "selected" do you mean "yes" is typed into the cell?
If you data is in A2:D15, select A2:D15.
Choose Conditional Formatting from the Format menu.
Change to Formula is and type =$A2="yes" and set your format.

--
tj


"sunderland27" wrote:

how would i trigger my rows to shade a particular color if a certain field
was selected "Yes"?