Hi,

I am looking for a macro that will look in a column range of G2:G500 and change the cell to red if the text in the cell reads 'Risk' but leave blank if states 'No Risk'

Many Thanks
Shelby761