Hello experts, I need a hand with formula based conditional formatting. I need to colour the cells in two columns where there is a difference against a target value. This target value is held in one of the cells and is changed weekly.
I've attached a sample spreadsheet which hopefully illustrates my question
Thanks for any help or suggestions