Conditional formatting in Excel
I have a workbook saved for members of our racing team (each person on a row) to signify their availability for each week’s racing during the season (columns). I’ve set it up with a data validation (for yes/no/no response) and once they make their choice, I’d like the conditional formatting to kick in and make it easier to see how many are in for a given week, so I was thinking a YES entry would -> green fill/dark green text, NO-> red fill/dark red text, no response would stay with no fill. We have 20 people/rows, 22 weeks of racing/columns, and I want to try and do something once that would apply to all. When I went to conditional formatting, I couldn’t see how I set multiple options or specify the range of cells to which I want it to apply. Can someone help? Thanks in advance.
I have a workbook saved for members of our racing team (each person on a row) to signify their availability for each week’s racing during the season (columns). I’ve set it up with a data validation (for yes/no/no response) and once they make their choice, I’d like the conditional formatting to kick in and make it easier to see how many are in for a given week, so I was thinking a YES entry would -> green fill/dark green text, NO-> red fill/dark red text, no response would stay with no fill. We have 20 people/rows, 22 weeks of racing/columns, and I want to try and do something once that would apply to all. When I went to conditional formatting, I couldn’t see how I set multiple options or specify the range of cells to which I want it to apply. Can someone help? Thanks in advance. Read More