Try this...

Select cell B1
Goto the menu FormatConditional Formatting
Condition 1
Formula Is: =COUNTIF(F27:F41,"late")
Click the format button
Select the desired style(s)
OK
Click the Add button
Condition 2
Formula Is: =OR(F27:F41="ahead",F27:F41="on track")
Click the format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"Sandy82" wrote in message
...
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.