(I only have just learned I do not need additional formulas, thanks to you, but I also do not know how to make the cells change colors, specifically for the reasons listed above). I know how to make it change for one, but I do not know how to make it change for both, or how to set up the format condition.