Forum Discussion
Excel formula for turning names green if certain criteria are met by a particular date
Hello- I'm an educator attempting to create a positive parent contact log. I've created columns corresponding to weekly date ranges with dropdown menus for teacher names. The next column includes...
Hello,
Thank you for your reply. Please see my description in the previous reply. When I said "contact", what I mean was calling, emailing, or in some way communicating with a family about a student with positive praise. I've attached the file without the students' names here.
Thank you!
Hi Perrine Punwani,
I just did one CONDITIONAL FORMATING for August/September only.
If any student get "positive praise" in any of first three weeks. Name will turn into Normal.
If i understood wrong. Just explain more. Please see attached file.
- Oops. Nix my last message. I uploaded it into Google Drive and was then able to read the formula. Thanks again!!!
Thank you! This is perfect. For some reason, I can't see the conditional formatting formula you used. Could you include it here? What were the parameters?