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.

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.

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

"T. Valko" wrote:

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.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Sandy82" wrote in message
...
Absolutely brilliant, works like a dream thank you very much.

"T. Valko" wrote:

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.