Hi,

I'm currently trying to use conditional formatting to change a colour of the font in a row.

For example if you put a certain word into cell A1 it will change the colour of the text to green in cells A1 to A5. Just wondering how this can be done?