Conditional formatting is supposed to save time

I am a manager at an old folks home and I am looking to conditionally format a checklist. There are tasks to be done every few days for certain people. It is to track if my staff have cleaned residents wheelchairs. I have thought that the easiest way is to make a basic calendar and black out dates where it is not to be cleaned and then have a white box corresponding with a date and resident waiting for a check mark once it is cleaned. The complicating factor is not every person has a wheelchair.

So I have successfully used the formula =$B4="" to make the entire row black unless there is a Y in the wheelchair column. If there is a Y then the conditional formatting is off and the white boxes are revealed.

The issue is, I have over 100 residents that I need to track. How to I do this without making 100+ conditional formatting entries. I dont want to spend a day making a very breakable spreadsheet.

I have attached a sample of the sheet.

Thank you.

Well, that was easy. Thanks.

I certainly don't want to have it differentiate between y and Y. My biggest fear is making an amazing spreadsheet that "just works" and then I get a new job and no one knows how to fix it when they inevitably break it. And locking it down with a password isnt much better.

But thanks again.

I think we have to clean them every week or twice a week. I think its determined by a 500 page government document on how to take care of seniors. (Canada's socialist healthcare ) But if there wants a standard to follow they probably wouldn't get cleaned...