#1
|
|||
|
|||
Conditional formatting, manual fill when required
I am building a production schedule making use of Green, Yellow, Red (Fill) to show status relative to the date in the cell. If the date in the cell =<today() then Red fill (indicating past-due) however, once the work is complete I would like to change that cell fill to Green manually however, the formatting rule will not permit a manual fill change to the cell. Your guidance would be greatly appreciated. |
#2
|
||||
|
||||
Couldn't you add a column called " completed" and enter "x" or something when done.
If you take this into account in your CF it will change to green automatically
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to fill a cell at row and column intersection with conditional Formatting | Iraj | Excel | 10 | 12-02-2017 09:54 AM |
Chart Fill Patterns Conditional Formatting | aramaglia | Excel Programming | 1 | 05-15-2017 06:35 AM |
How can I count cells based on their fill color that was set by conditional format | trueimage | Excel Programming | 1 | 10-25-2013 12:08 PM |
Conditional color fill based on presence of data | avanderh | Excel | 11 | 07-28-2011 09:10 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |