| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting on 2nd cell
In Excel 2007, I want a column (C) to conditional color fill a cell if the
corresponding cell in (B) contains a certain word. I an't get the conditional formatting to accept my IF statement. Should I be using a different function? Example B1 contains Accepted, C1 turns yellow B1 contains Not Accepted, C1 turns green B1 contains Cancelled, C1 turns hot pink possibly others, but that's is the jist. Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting Based on cell A text with conditions in Cell B | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) | |||
Threaded Mode
