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
3 comments:
Use a conditional format with a formula like =INDIRECT("C"&ROW())="Past Due" and set the background color to red. Add similar rules for the other formats you want to apply. Replace "C" with the actual column holding the values you want to check.
law essay writing service
Please try to add similar online mock tests for reasoning section also
nift entrance exam study material book
Thank you for your articles that you have shared with us. Hopefully you can give the article a good benefit to us. La Mode Clothing
Post a Comment