Change cell background coulor

D

Des

Hi, I need to change the background coulor of a cell depending on the weight of a person entered in that cell. Is it poss to do along the lines of: if cell a1 = 80kg then background coulor = red?

Des
 
D

Dirk Goldgar

Des said:
Hi, I need to change the background coulor of a cell depending on the
weight of a person entered in that cell. Is it poss to do along the
lines of: if cell a1 = 80kg then background coulor = red?
Click to expand...

Access doesn't have "cells" as such. Is this a question about Excel?
If this is an Access question, and by "cell" you mean a text box on a
form, then if you're using Access 2000 or later you can use Conditional
Formatting to do this. It's on the Format menu when the form is open in
design view.
 
Top