Forum Discussion
Excel formula for turning names green if certain criteria are met by a particular date
Hello,
it's difficult to suggest formulas without seeing the structure of the data. Could you upload a sample file? I'm also a bit confused about your description. Did you really mean "contact" everywhere you write "contact"? If so, I don't understand where the "comments" come in.
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?
