Question about automatically changing the cell’s color

  • Thread starter Thread starter saud
  • Start date Start date
S

saud

How could I make the cell changes its color automatically based on the
type of information I enter.

Thanks, for any help

(e-mail address removed)
 
Try Conditional Formatting (CD)

For example:

Suppose you want the cell's background color
to change to light green if the value entered is > 10

Click on A1
Click Format > Conditional Formatting

Set under Condition 1:

Cell Value Is | greater than | 10
Click Format button > Patterns tab > Select: light green > OK
Click OK

Now test it out by entering various values into A1
some < 10, some > 10.

The cell color will change to light green with values > 10

For more info, try MVP Debra D's page on CD at:

http://www.contextures.com/xlCondFormat01.html
 
Back
Top