Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-24-2018, 07:43 AM
kbc kbc is offline Conditional formatting, manual fill when required Windows 10 Conditional formatting, manual fill when required Office 2016
Novice
Conditional formatting, manual fill when required
 
Join Date: Mar 2018
Posts: 1
kbc is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 03-24-2018, 07:50 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Conditional formatting, manual fill when required Windows 7 64bit Conditional formatting, manual fill when required Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


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
Conditional formatting, manual fill when required 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 formatting, manual fill when required 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft