Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the text in column D would you please be able to help
many thanks.
Related:
Colour changing in rows determined by text in 2 different cells