Conditional Format for one cell based on range

  • Thread starter Thread starter Sandy82
  • Start date Start date
S

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.
 
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
 
Back
Top