I am trying to make a Checkbox in cell F10 automatically tick when Cell F11 has the word ‘Yes’

I have tried many solutions found online including the two below and some more complicated ones and It will not work. The cell will change colour but cannot get the box to tick.

Cell F11 dose had a formula already in it to take a value from another cell in a different sheet.

=IF(F11=”Yes”, TRUE, FALSE)

=F11=”Yes”,TRUE, FALSE

I have spent a few hours searching on google and evey formula/solution I have came across hasn’t worked,most of the forumlas, half work by chaging the backgorund colour that is select in the conditional formatting tool.