• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting with dates


I have attached a spreadsheet which contains the following three questions:

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.