Excel: use cell color fill as input for cell formula

Question

I'm using Excel to manage our production schedule. Each cell has a formula that returns a date by which each step in the production process should be complete.

Today, I fill each cell manually to indicate:

 Green  = On-schedule
 Yellow = Threat
 Red    = Behind Schedule

I am seeking a formula that does the following:

If cell address is not Green AND cell value is less than TODAY(), then paint it to Red

I also need the ability to override the formula and change cell fill to Green once production has caught-up. Simple conditional formatting does not allow manual overriding.

Maybe you hit the OK button before finishing your question, could you please complete it? — sɐunıɔןɐqɐp
@sɐunıɔןɐqɐp I've fixed the text because everything after a < was invisible. — Thomas Fritsch
Possibly you want to use the cell's color index for your formula. Take a look at this one: stackoverflow.com/questions/24382561/… — sɐunıɔןɐqɐp

S. Mayol S. Mayol · Accepted Answer · 2018-04-28T16:27:22

What I understand that you are trying to do is to change the row color based on a cell's value in Excel. This is performed by Conditional Formatting in Excel

Here I am going to provide you another link also that clearly explain How To Change Background Color Based On Cell Value In Excel?

I hope this help you.

Excel: use cell color fill as input for cell formula

1 Answers