CODEWITHSUNDEEP
excelexcel-formulaexcel-2010autoformatting
KBC
KBC

Reputation: 31

Excel: use cell color fill as input for cell formula

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:

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.

Upvotes: 3

Views: 4410

Answers (1)

S. Mayol
S. Mayol

Reputation: 2625

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.

Upvotes: 1

Related Questions