I have a database with a Date field, Name field and a checkbox labeled Utilized.
Each record is a request to work an overtime shift.
If a person works overtime, they are checked as utilized...I have sucessfully turned on conditional formatting to make the background red for that person on that particular date. That part was easy.
NOW, what I want to do is for every unique Name which is checked as Utilized within the last 14 days to show up yellow, so that those who have requested, but haven't worked overtime get preference.
I just can't come up with the expression that will make it work.
Any ideas?