Hi Gary - yes, I was talking about cells. I appreciate the response but I'm
still not sure howto use what you have given me. I've tried to test by
plugging a statement into a cell but receive errors.I also tried an"=" but it
didn't like that either.

Thanks,

Jeff

"Gary Brown" wrote:

What do you mean by 'fields'?
If you're talking about cells.
myrange.Interior.ColorIndex = 6 'yellow
myrange.Interior.ColorIndex = 3 'red
myrange.Interior.ColorIndex = 5 'blue
If you're talking about listboxes, textboxes, comboboxes...
Me.ListBox1.BackColor = "&H0000FFFF&" 'yellow
Me.ListBox1.BackColor = "&H000000FF&" 'red
Me.ListBox1.BackColor = "&H00FF0000&" 'blue

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"JHG" wrote:

I'm trying to use "IF" staements in Excel to pull values into fields as well
as to change the field fill color based on certain parameters. Pulling the
values in is the easy part, but can the field fill colors be controlled as
well?