Need help with an IF statement or formula

  • Thread starter Thread starter Sal
  • Start date Start date
S

Sal

I would like to set up a formula or IF statement in my
spreadsheet so that if I enter a certain # the cell turns
green, and if I enter another # it turns red and so on.

Example: If the # entered in a cell is > than 6 cell is
Red, but if # entered is < than 6 the cell is Green, and
if # entered = 6 the cell is yellow. I would like the #
to be displayed in the cell as well as the color.
Thank you for your help.
 
Sal,

You can use Conditional formatting.

Select the cell (or range). Go to Format>Conditional
formatting. Write the conditions in the white boxes. You
can have as much as 3 conditions.

Regards,
Felipe
 
Back
Top