Conditional Formatting based upon Options Button

[Chymara]

Hello!

I have a spreadsheet that monitors open issues with suppliers and in-house supervisors. For the supervisors, I have it set up so that they have 5 days from the time I give it to them to respond, and if they do not, it highlights the due date in red so I can remind them. However, if they do respond, there is an option box they can check that says "closed", then I have to manually go in there and change the red highlight to green to show it's closed. Is there a way I can make the cell turn green itself once the "closed" option is checked?

Thank you!

[DBY]

Hello
If for example the linked cell of the option button contains 1 for closed, then apply the following CF formula:

Please Login or Register  to view this content.

Here the linked cell is E2 with an absolute reference to column E.

Hope this helps.
DBY