| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Conditionally Format Other Cells or Rranges
I want to have a cell or a range of cells be formatted with a pattern or a
border or both, or even unprotected (if not too complicated) whenever another cell in the Status column displays the string: "DONE". Is it possible to use Conditional Formatting for that? Or would I have to use an IF statement instead? I've managed to have a simple IF statement display directions whenever the DONE text shows up in the Status column, but don't know if it's feasible to use it with formatting of another range. Is it and if so, how? -- Rene - Do appreciate your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditionally format anumber format | Excel Worksheet Functions | |||
| How can I conditionally format cells that contain formulas? | Excel Discussion (Misc queries) | |||
| How do I conditionally format a chart? | Charts and Charting in Excel | |||
| conditionally format cells | Excel Worksheet Functions | |||
| How do I conditionally format a chart? | Excel Discussion (Misc queries) | |||
Threaded Mode
