Hello Excel/VBA People,
I am looking for a vba code that will replace the value of a cell (with yellow color) to zero for those columns having Dates as the Header column only. Example: In a certain excel file there are tabs/sheets that contain the column names Supplier name, Amount, and dates...
I am looking to have a column of dates (column G) fill GREEN based off the conditions:
1. If there is a "P" (stands for portables) in column F
2. If the date listed in column G is over one year old (365 days+)
I am also looking to have the same column of dates (column G) turn GREEN...
I have this formula for Conditional formatting =ROUND($D$3*$C7,)>D7 and what I want to do... If the formatting is applied to any cell in range D7:NE41, then I want to apply that same formatting to D45:NE79 - the issue is that if I add that second range to the "Applies to" section of the...
I am currently sitting with the following material overview file in Excel:
I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...
I'm using Excel 2016. As I keep fine-tuning my stacked area chart's configurations, I find it hard to keep track of the fill colors and series colors. I want to display, for example, in cells B40 and C40 series1's Fill color hex code and series1's Fill color's transparency. And then B41 and C41...
I have seen values like vbgreen, vbblue,vbred etc. Is there any list that show all VBColor list? like the list below but more colors. Thank you very much
I have set of numbers in a range , say B2:F6, that are colored differently due to conditional-formatting. I'm looking for a sub to find/identify say YELLOW cells in range B2:F6, then copy YELLOW cell values, then paste the values into YELLOW col. starting in cell B10, and do same for other...
Does anyone know code that will copy a template worksheet multiple times?
Original Sheet Name: Week Template
I plan to have one worksheet for each week in the year (52 plus the 'Week Template' sheet
1) row height
2) column width
3) fonts style sizes and colors...
Is it possible to set custom hot keys for colors? For example, instead of Alt+H+H and then arrow keying to the color I want to select, is there a way to set Alt+H+H+1 to, say, white, and Alt+H+H+2 to black, Alt+H+H+3 to the third color in the palette, etc.?
is there any way that I can coloured the first two rows in a worksheet automatically after applying the filters?This is the overall problem :I have got a sheet with columns like thisitem price criteria1 criteria2I have to frequently filter and note down the price of the first two rows of the...
is there a faster way besides using conditional formatting to color specific columns like in VBA. I want to have the cells for example in C4-C53 g4-g53 k4-k53 etc etc to change colors if they are less than or equal to 1. i have 40+ columns to do so as you can see doing it in conditional...
Does anyone know how to hange chart line colors in vba 6.0?
I tried the way vba 7.0 uses to change them, but it fails.
I can't update its version or install an updated excel cos it's my company's pc and they forbid any new app installation.
I'm trying to format my tab colors based on cell value in column I.
"At Risk" - Red Tab
"In Progress" - Green Tab
"Not Started" - Yellow Tab
I need it to apply to all worksheets, range for all worksheets is I9:I30
All the macros I have tried don't seem to help me.
Hi. I have a data set that is annual values for various colors. For each of these colors, in any year the value will be 0 or greater. For each year, I would like to have a cell list all the colors that are non-zero for that year. For instance, for the table below (apologies for formatting)...
I would like to modify my existing drop down lists to dependent ones. I have followed some of the online tutorials and made some of my own samples to learn how do make a basic dependent one. I would like to know if something is possible and below is a small sample of what I am working with...
I am trying to do a If And with a vlookup within the same workbook.
IF(AND(IF(AF3431="Red",VLOOKUP(AG3431,'VLookup Table'!E:F,2,FALSE),IF(AF3431="Blue",VLOOKUP(AG3431,'VLookup Table'!E:F,2,FALSE),IF(AF3431="Green",VLOOKUP(AG3431,'VLookup...