Rule to turn on specific cells

[2tall2call]

Hello All. I made a daily check list in Excel for my jobsite superintendent to fill out, print and file every day. Let’s make a scenario, When the painting contractor now starts and is on the job, one of the check boxes that must be checked is the “Fire Safe Rag Container” cell. It’s the only trade that needs that cell to be checked because they are the only trade that uses that container, Is there a way that when I tell Excel that the painter, (That is of- course his own cell using a drop down arrow next to the cell that has the painter along with many other trades to choose from) is on the job, the cell that contains the wording, “Fire Safe Rag Container” now appears on the check list and ready to be checked that that container is on the job? Or another example, every day we check a cell that means no injuries happen that day. Heaven for bid we had to check the box that said we did have an injury today, At that time a row will appear that we need to fill out what caused the injury and so forth. But it only shows up when the injury box has been checked “Yes” and if no injuries have happened that row does not appear?
I hope this made sense.
Mike.

[Glenn Kennedy]

As you can see, there's a problem with some characters in your post!! A regular problem here!!

Please post an Excel file that meets the guidleins shown in the yellow banner top of page,

[AliGW]

Administrative Note:

Welcome to the forum.

Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.