Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format for one cell based on range
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format based on value of another cell | Excel Worksheet Functions | |||
How to conditional format columns in a range based on | Excel Worksheet Functions | |||
Conditional format a cell based on another range of cells | Excel Worksheet Functions | |||
Conditional Format based on range | Excel Discussion (Misc queries) | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) |