I'm trying to add conditional formatting to a column I added through text mode. I can't seem to get the conditional formatting correct even with all the statements.The column is a question and answer from a scorecard. If the answer is < 10%, I'd like it to be red background with red text. If I can a...