I have the below scenarios:
Status__c field on Account - New, In Progress, CLosed StageName field on Opportunity - New, In Progress, Closed
Scenario 1: Whenever Status__c field is changed in Account, the stagename of all the related opportunities of the account should be changed to the value in Status__c field of account.
Scenario 2: When StageName of Opportunity is changed to In Progress, Status__c of its related account should change to In Progress. This update on account should not change the StageName values of the related Opportunities.