I'm having trouble putting together a correct formula or workflow to do certain tasks. I have a rent tracker spreadsheet and want a formula to basically say "When it's 30 days prior to the Rent Increase Date then automatically turn the Status Column drop down to red. Once the Status Column drop down is changed to green then have the Current Rent Column change to the Rent Increase Column amount".
I have a separate Monthly Rent Pay Spreadsheet that I would like to cell link to the above referenced sheet. That part is easy to figure out. BUT is there a formula or something I can set up that says if any changes have occurred in the linked cells then highlight them a certain color? I want any changes to stand out because I make changes through out the month and put it all together at the end of the month.