Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
color cells based on multi criteria
I am new to the vbe. I need help with a data extraction that I am currently
doing manually every month with the CF function. This data is pulled fresh every month and is not in a running spreadsheet. The Columns however are consistent with the data that is populated. I am using 2007. In Column B I have Customer Name. In columns J through U I have order qtys for the next few months. I would like to search through column b and every customer "xyz" finding go to cols J:U and look for the values 50 and 1000. If the value is < 50 then color fill with Green and Bold Italic the font. If the value is greater than 1000 then color fill with red and bold italic the font. Thanks in advance for the assistance. CB |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
color cells based on multi criteria
You don't need VB for this. Just use conditional formatting.
On Apr 3, 10:44 am, CB wrote: I am new to the vbe. I need help with a data extraction that I am currently doing manually every month with the CF function. This data is pulled fresh every month and is not in a running spreadsheet. The Columns however are consistent with the data that is populated. I am using 2007. In Column B I have Customer Name. In columns J through U I have order qtys for the next few months. I would like to search through column b and every customer "xyz" finding go to cols J:U and look for the values 50 and 1000. If the value is < 50 then color fill with Green and Bold Italic the font. If the value is greater than 1000 then color fill with red and bold italic the font. Thanks in advance for the assistance. CB |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
color cells based on multi criteria
This would require a format every time that the new data is pulled. I would
like to be able to run a macro on multiple new files. Anyone else with a solution? "Jason Lepack" wrote: You don't need VB for this. Just use conditional formatting. On Apr 3, 10:44 am, CB wrote: I am new to the vbe. I need help with a data extraction that I am currently doing manually every month with the CF function. This data is pulled fresh every month and is not in a running spreadsheet. The Columns however are consistent with the data that is populated. I am using 2007. In Column B I have Customer Name. In columns J through U I have order qtys for the next few months. I would like to search through column b and every customer "xyz" finding go to cols J:U and look for the values 50 and 1000. If the value is < 50 then color fill with Green and Bold Italic the font. If the value is greater than 1000 then color fill with red and bold italic the font. Thanks in advance for the assistance. CB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
color a range of cells based on a criteria | Excel Discussion (Misc queries) | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
Loop criteria based on cell value and color | Excel Programming | |||
Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
How do I do multi VLOOKUP's based on certain criteria per cell? | Excel Worksheet Functions |