column width

[SUVERMO]

Best,

is it possible to link the column width with a formula to the value of a cell?

Attached a part of a worksheet.
If, in column BJ, the rows 1,2,3,4 and 5 are changed to NO, the value in cell BJ7 changes.
The intention is that the column width BI is automatically adjusted to the cell content of BI7.

[Fluff13]

A formula cannot change the width of a column.