Hello

I need to add conditional formatting to a cell (B1) based on a column of
cells (F27 to F41). The cells contain a pick list of text "Ahead", "On Track"
and "Late". If the cells in the column contains the text "Ahead" or "On
Track" or a mixture of both then B1 should turn green but if any of the cells
contain the text "Late" B1 should turn red. Please could you help.