| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional Formatting
Good Day – I am looking for a Conditional Format that will change any cell that is inputted into my worksheet under the formula =COUNTIF(2:2,"DT *"), which may bring something back for example = DT 06/09 which can change the cell to green (COMPLETED). I would like it displayed as DT 06/09 (but with the cell filled in green) I hope you get a full understanding of what I am looking for, once initials and date are entered i would like the conditional format to run and shade the cell green! I hope you can help with this frustrating issue. My work sheet runs from L3 to CR77. Thanks for all your help
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting--different formatting depending on cell con | 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 that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
