High all, I must be under the influence of the weekend blues because this is just not working for me. What I'm trying to do is to format cells in color based on the text in another cell. So if the text in cell J5 is "Shipped" I want to color format in B5. Then I will drag that conditional formatting down to J102.