Forum Discussion
Excel formula for turning names green if certain criteria are met by a particular date
Hello... I am also an educator and would like your permission to use your idea to track our parent contact. We are using a similar, but slightly more complicate database for tracking our student growth; however, I really like the idea of using it the way you have intended. Thanks!
Feel free! I'm flattered! As I learned many years ago, the best teachers "borrow". I ended up creating different tabs for each month in order to continue the highlighting formula. I also added a "notes" section in the final column for teachers to write any necessary info about the content of the contact. My colleague had suggested adding a column for method of communication, but I was afraid of making the spreadsheet too cumbersome.
I'm having a little glitch now. Only column A changes colors if there is one entry of positive praise. Column B will only change if there are two entries for positive praise. I changed the background color to red instead of having it in red writing, too.