Can Excel's field fill colors be changed using "IF" statements?

  • Thread starter Thread starter JHG
  • Start date Start date
J

JHG

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