Hi All

I am after a formula that will allow 4 different colours to be displayed on a conditionally formatted data bar, based off the text in another cell.

Really appreciate all your help