muna
Member
I have attached a spreadsheet which contains the following three questions:
Can you help?
Thank you in advance.
1) Please could you set it so that once today's date finishes then the cell of all dates within each month turn green. I imagine conditional formatting can achieve this? |
2) Under the Attendance % field (cell O4) can you please put in a percentage for each person so Alice would be 11/12 * 100 (one time she cancelled). I want the formula to understand that having a date in means the percentage increased. I don't want it to think an empty cell or anything other than a date should increase the percentage. |
3) When it is the month i.e. Now is June… Can you have it so that all of June entries are highlighted? And for it to automatically highlight July entries when July 1st comes… |
Can you help?
Thank you in advance.