Change cell background coulor

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top