I have a spreadsheet with names in column A. I'm keeping attendance by placing an "X" in each subsequent column when the person is present (week by week).
I'd like for Excel to automatically change the range of cells to RED when the cell plus it's preceding two cells are blank, effectively showing red when someone has been absent three weeks in a row.
How can I accomplish this using Excel 2010?
No comments:
Post a Comment