How to turn one cell red if there is a red cell in another cell - but for an entire column of rows.

Hi there,    I am trying to determine how to turn one cell red in a column, if there is another red cell in that same row, but for a series of columns.   Here's more context to better explain. I ...