Use the following formula in the cell:
Depending on regional settings (country), you may have to use commas instead of semicolons in the formula.
Then use Conditional Formatting in the Format menu, on the cell that contains the formula, using the following criteria:
[Cell Value Is] [equal to] [=“F”] with Format set to Color Red
Welcome to the MyCE forums!