Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting based on another cell
Hi there,
Basically i want cell F6 to change colour if cell F5 reads "Failed". I can't seem to get the formula right! I don't know if it makes a difference but in cell F5 i have used the Validation function with a list of 2 options: Failed and successfull. Any help would be greatly received, cheers James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
Conditional Formatting Based on Date | Excel Discussion (Misc queries) | |||
conditional formatting based on column | Excel Discussion (Misc queries) | |||
Conditional formatting row when cell value is an even number | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |