Iwatani Butane Substitute

Coloring cells you've already checked automatically

Jorge query:
hello, my question is this: how do I get in an entry in a particular cell, another cell X is painted a color?

This problem is solved using formulas Conditional Formatting.
In the example, cell B1 is painted red if A1 contains the value 2.
Cell B2 is painted yellow if A2 contains a value greater than or equal to 30.
and B3 cell is painted green if cell A3 it says "paid."

Click image to see better