Trigger - Update Number Field with Formula Value - en masse

Question about Triggers. Any help would be greatly appreciated!

I have a table that calculates a Price formula. This Price formula is compared to a Current Website Price number field. When there is a mismatch in these values I want to create a trigger to update the Current Website Price number field with the value of the Price formula.

I have tried a few things but none of them work very well:

I put a Trigger on Update on a Yes/No field such that when it is "yes" the trigger updates the value. HOWEVER... I have to manually change this field on EVERY record individually.... I cannot do a bulk update or a drag/copy and have it work.

Also put a trigger in an On Click formula field that compares the 2 values, which works, but I have to manually click on that formula field in Form View for it to work. Ugh!

I have >10k records, so clicking on each isn't feasible.

PLEASE HELP!!! Thanks in advance!