I need a rows font colour to depend on a certain word in a cell. The only words would be...

connected-green, expired-orange, job on going-blue.

If you need anymore information please ask.

Thanks