Forum Discussion
Perrine Punwani
Aug 02, 2017Copper Contributor
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...
Mike and Michelle Blue
Aug 02, 2017Copper Contributor
Hi Perrine - Thank you so much for letting me use yours. Good teachers borrow from others, so thanks again.
I had the same issue while working on a different spreadsheet for growth tracking (colors not working the way I wanted them to). The trick is to highlight everything that you want to change colors, not just one cell, and create the rule. Or you can go into "conditional formating" and edit the ones you've already created and make it conditional for a range of cells. Hope that is helpful and thanks again!