How do I change cells from different cells?

So I wanna change the colour of an individual cell within a table from a different cell without effecting the £100 (example number) as every time I use a formula such as =$E$23=“paid” and then change format colour to green it obviously won’t be able to display the £100 it would have to display the paid but I wanna be able to keep the number in the cell intact without words within it just the number £100 so in short words I wanna be able to change a cell (example E24) to green without changing the number within (£100) from a different cell (for example CB24) so anyone have any solutions on how I can achieve this please let me know.

I will not be sending my sheet for anyone to do it for me i just need to know what formula I need to create to do this as I’ve tried so many ways but none work.