S
sunderland27
how would i trigger my rows to shade a particular color if a certain field
was selected "Yes"?
was selected "Yes"?
P
PauwlL
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
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
D
Don Guillett
format>conditional formatting
T
tjtjjtjt
You could use Conditional Formatting.
By "selected" do you mean "yes" is typed into the cell?
If you data is in A2
15, select A215.
Choose Conditional Formatting from the Format menu.
Change to Formula is and type =$A2="yes" and set your format.
By "selected" do you mean "yes" is typed into the cell?
If you data is in A2
15, select A215.Choose Conditional Formatting from the Format menu.
Change to Formula is and type =$A2="yes" and set your format.