Conditional Format for one cell based on range

[Sandy82]

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.

 

[T. Valko]

Try this...

Select cell B1
Goto the menu Format>Conditional 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

 

[Sandy82]

Absolutely brilliant, works like a dream thank you very much.

 

[T. Valko]

You're welcome. Thanks for the feedback!