Unanswered: Need help with a conditional formula to highlight cells based on text in another cell
Hello Excel Experts,
I have text in Column B and number values in Column C. I would like the font in Column C to turn Red if the value (Column C) is > than 100.
So, I would like to create a conditional formula to look at Column B and turn the font Red in Column C if the value is greater than 100. So, in Column C, 200 and 150 will turn Red because their values are greater than 100.