Suppose you want to change the color from rows 1-10 by putting a "yes" in column F
a. Select the rows 1-10
b. with the rows selected, click conditional formatting while selecting those rows.
c. click new rule
4. click "use a formula to determine which cell to format"
5. Put =INDIRECT("F"&ROW())="Yes"
6. Click format and change the color
7. click ok
8. click ok
9. click ok
10. You are done
a. Select the rows 1-10
b. with the rows selected, click conditional formatting while selecting those rows.
c. click new rule
4. click "use a formula to determine which cell to format"
5. Put =INDIRECT("F"&ROW())="Yes"
6. Click format and change the color
7. click ok
8. click ok
9. click ok
10. You are done
