I am trying to conditionally format a row if any cell in that row contains the text "R" or 'r". I would like to change the row (specific cell ranges) to Green.
I have tried formulas in CF, but it always seems to leave out the cell where I input an R/r. Any suggestions?