Forum Discussion
AmberTafolla
Aug 16, 2024Copper Contributor
Conditional Formatting with Multiple Cell Values
Hello, I am hoping someone know how to help me set up conditional color coding in excel. I am needing certain cells to populate one color if the others cells are filled out wrong and another color if...
AmberTafolla
Copper Contributor
I can't have the default be red, or the people entering the information on this spreadsheet won't be notified that they entered something in wrong. That is why I was looking for information on how to create the different formulas.
The spreadsheet needs to start off blank and then populates with color when information is entered right or wrong so that person knows if they need to fix their entries without me having to tell them.
If I know how the formula works I should be able to adjust it for all the different conditions.
The spreadsheet needs to start off blank and then populates with color when information is entered right or wrong so that person knows if they need to fix their entries without me having to tell them.
If I know how the formula works I should be able to adjust it for all the different conditions.
HansVogelaar
Aug 19, 2024MVP
As long as the conditions for green are not satisfied, there will be something missing or incorrect, so it's reasonable to color the cells red...
- AmberTafollaAug 19, 2024Copper ContributorExcept some of the rows may need to be skipped because they don't need to be filled out at that time in which case they shouldn't be colored in since the information isn't wrong or missing.
If I knew how the formula worked I would be able to adjust it for all the different conditions that I need since this isn't an easy peasy spreadsheet where one format condition will work. - HansVogelaarAug 19, 2024MVP
You can easily translate the conditions to formulas. For example, red if
job has number and work center is f1il and code is entered and hours are blank or "0"
translates to
=AND($A2<>"", $C2="F1IL", $E2<>"", $G2=0)
Similarly
job has no number and work center is not f1il or blank and code is blank and hours are greater than .17
translates to
=AND($A2="", $C2<>"F1IL", $E2="", $G2>0.17)