25
• Conditional Formatting changes the cell ’ s shading and font color according to the rules established which , in this case , is based on the results of the formula
• For more details on how to use Conditional Formatting , refer to Pastor Excel articles from the Fall and Winter of Pastor Excel summer 2019-Flash Fill . docx 2015 . See the note below on how to access these articles .
TCN PROFESSIONAL JOURNAL FALL 2021
• If 12 or more combined “ No ” and “ Abstain ” votes are received , Cell A4 changes to “ FAILED ” and displays a red background with white text
• In this example , after 21 of 23 potential votes were counted , Fred was approved to serve on the Board !
I hope this article helps you sharpen your Excel skills , provides an additional resource for your ministry , and helps you get work done in a more efficient manner .
Download the workbook used in this article .
Try these tools with the same spreadsheet used to write the article . Go to
www . TCN . theglennwood . com and download the file titled “ Pastor Excel Church Vote . xlsx ”.
Access to previous Pastor Excel articles is now available on the TCN eLearning website !
Did you know that every Pastor Excel article is available online ? TCN has added all Pastor Excel articles to the eLearning website , and they are available to download FOR FREE as part of your TCN membership .
Author
Glenn Wood , CCA , is the pastor of administration for Seacoast Church where he has served since 1995 . He can be reached at
glennwood @ seacoast . org .