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...
Hi Perrine Punwani,
For highlighting use CONDITIONAL FORMATTING.
If you give screenshot of sheet or excel file, we can solve.
Thanks. I've attached the file here.
I'd want the formula to highlight the names in columns A and B red if a family has not been given positive praise about the student by the end of the third week of the "month". For example, for August/September, the names would turn red on 9/15. That would let us know who still needed to be contacted.
Or more simply, I just want to know how to turn the names of families who have been contacted over a 4-5 week period to turn green. I'd want that to reset at the beginning of each 4-5 week period.
Thanks!
