In Office2003 (you don't specify the version, so I'm presuming) you do the
following:

Select FORMAT..CONDITIONAL FORMATTING.
Select FORMULA IS instead of CELL VALUE IS in the first drop-down.
type as formula (e.g.) "=(B5=true)".
Click the FORMAT button, and under PATTERNS TAB, select the back-ground
colour you want.
Click OK & Bingo.

good luck.

PauwlL

"sunderland27" wrote:

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