Combining Yes/No Option Buttons with Conditional Formatting

[DavidWF]

I have a worksheet where several cells are conditionally formatted. I have other cells that contain yes/no option buttons. Despite hours spent trying to figure out how to combine the two I am unable to achieve both conditions - I want the cell containing the yes button to have green fill when "yes" is selected or have no fill if "no" is selected, similarly I want to the cell containing the no button to have red fill when "no" is selected or have no fill if "yes" is selected.
If what I'm trying to do is actually possible I'd be grateful for guidance on how to do it.

 

[DanteAmor]

Maybe the following can help you:

example cf link cell.xlsx
	A	B	C	D
1		Value	Option	Link
2		1		FALSE
3		6		TRUE
4		10		FALSE
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B4	Expression	=Y($B2>5,$D2)	text	NO

In my example, cells B2 to B4 have conditional formatting, if the value is greater than 5 the cell is highlighted in green.
But the check box must also be active.

Notice how the checkbox is linked to the cell in column D.
So the complete condition is, if cell E2 is greater than 5 and cell D2 is true, then it highlights green.

I attach my example so you can see how it is organized.

Loading Google Sheets

 

[DavidWF]

Thanks DanteAmor. I couldn't translate your suggested solution to my problem as I was trying to conditionally format the cell that contained the option button, however you certainly pointed me in the right direction with the use of a Link cell. I've never used Link cells before, so this was a new learning for me. I've now set up a series of link cells outside the visible limits of the worksheet and use the values in these cells to conditionally format the cells containing the option buttons.

Excellent outcome - thank you so much for pointing me in the right direction.