Conditional Formula?

A regular formula in a cell can only show a value, not change colors. To get a color based on a number in another cell, you use Conditional Formatting.

Here’s a quick way to do it:

Let’s say your number is in A1, and you want B1 to be green if A1 is greater than 10, and red if not.

1. Select cell B1.
2. Go to Home → Conditional Formatting → New Rule.
3. Choose “Use a formula to determine which cells to format”.
4. In the formula box, type the test for green:
   =A1>10
   (no IF needed—just the condition)
5. Click Format, pick a green fill, then OK.
6. Click New Rule again, and this time enter the red condition:
   =A1<=10
   Set the fill to red, then OK.

Now B1 will automatically change color when the number in A1 changes.

You can adjust the cell references and the number to suit your sheet.

Hope that helps!