shaded rows
 

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

shaded rows
 

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"?

shaded rows
 

formatconditional formatting

--
Don Guillett
SalesAid Software

"sunderland27" wrote in message
...
how would i trigger my rows to shade a particular color if a certain field
was selected "Yes"?

shaded rows
 

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"?