| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel's field fill colors be changed using "IF" statements?
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can Excel's field fill colors be changed using "IF" statements?
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can Excel's field fill colors be changed using "IF" statements
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can Excel's field fill colors be changed using "IF" statements
Those were answers if you're using macros.
Use Conditional Formating to change the colors depending on the cell contents. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "JHG" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can the Excel cell fill color be changed using "IF" statements? | Excel Worksheet Functions | |||
| Used drawing colors in shapes....lost default colors for "Fill Col | Excel Discussion (Misc queries) | |||
| Run macro only if Field E10 = "WO ID" and AB10 = "Spec Sizing" | Excel Discussion (Misc queries) | |||
| Run macro only if Field E10 = "WO ID" and AB10 = "Spec Sizing" | Excel Discussion (Misc queries) | |||
| "More Fill Colors" does not appear | Excel Discussion (Misc queries) | |||
Linear Mode
