I am looking for the proper way to have a formula inserted into a cell if another cell is change and doesn't equal "Rotating".
The Named Range is Shift_Select and I need it to look in the Second column of the named range (the change actual column is F2:F) and change if cell value <> "Rotating". If that is true then insert a basic
equals formula in the first column in the Named Range (the actual column is E2:E)

something like

=F"cellrow"