Here is something I would like to do but I don't know if it's possible:
When I input a percentage in a cell (ie 50%) I would like 50% of the background of my cell to be for instance red. (and still 50% written in text above)
Is it something possible to do in excel ?
I'm trying to add a textbox at the current position (selected cell) with a set size, fill color, and border color. I found this: http://msdn.microsoft.com/en-us/libr...8(VS.80).aspx:
1. By entering a numerical value in Cell A1 for example typing 5. 2. Then, next five columns would be blocked with specific color. 3. if i am typing 10, then 10 columns would be blocked with specific color.
I would like to fill some cells with a customer id if this customer is the same as the cell bellow. As my example below.
CUSTOMER idCUSTOMER NAME TYPE 737346 Nikos 81 1154765 Kyriakos 81
1154780 Thanos 81
I would like to fill automatically the empty cell bellow Kyriakos the customer id 1154765 in new column. I want in column "new" to fill with customer id and when the customer id is empty to fill the same customer id as above customer id.
I am trying to create a program that when a cell changes to a specific text from a pulldown menu of two items the active sheet's tab changes color depending on what is selected. Is this possible using the pull down menu, and how would you go about doing this?
I have sheet "MySheet" with data in range A1:B200, when i change or select value in combobox, my textbox will fill. But i need return respective rows in column A inside textbox.
VB: Private Sub ComboBox_Change() On Error Resume Next TextBoxCod.Value = WorksheetFunction.Index(Range(MyRange"), ComboBox.Value, 1) End Sub
I have a drop down list in cell F1 with all the months. In G1, I would like it to automatically display the number of days in the selected month. Of course it depends on the current year (due to leap year, etc).
Still adjusting to 2010 Excel...How do you use the automatic fill in feature of formulas; e.g. when typing =convert....a fx function appears....not sure how to use it
In a spreadsheet a macro calculates some percentages and populates a small table, copies the table and generates an email. The table includes conditional formatting to fill a cell in green if it is above 95%, or red if it is below 95%. The spreadsheet works fine, but with every possible solution I have tried including converting to HTML, the color cell is always red in the outlook email. I am guessing it is because in the transition to the email, the small table no longer is located in the cells that are used to do the color format.
Whats odd is when I copy and paste into outlook it works fine, but I have been unable to figure out how to paste into the body of an email using excel vba. I have read many posts from people with similar issues, most have no solution. I am currently attempting to convert the table into a gif and try inserting that into outlook. Due to the proprietary nature of the spreadsheet, I am unable by policy to publish any code.
I've created the attached and want to get the top 10 values from column E of the INPUT sheet when a different name is selected in the drop down list in D1 on the summary sheet. I also want the relevetnt house number, Street name and Pososte code to populate I want to do this using VBA. How would I do this. top%2h010(1).xlsm
I would like to have a cell automatically change text based on a conditional formatting formula. When the cell color is red, or the formula is true, then display the word "Expired". Can a formula be devised using results from conditional formatting?
This is being used for expired CPR 2-year certifications. When the certification expires, the cell currently turns red (based on a cell formula) and I would also like the word "Expired" to replace the date.
I, daily get a list of individuals with some data against each one of them. E.g Amit would appear 7 times in the list, John would appear 10 times in the list and so on and so forth. I am required to sort the data as per names and then fill one background color. One color for one person so that it becomes easy to read data specific to an individual.Ia there a way that the color fills up automatically. note the names and number of entries are not same everyday.
I want to select an automatic colour scheme (font) for an Exel sheet. It has 3 columns with values. If the coloums are A, B & C I want to mark the higher value in red. If B is higher than A, B should be red. Again if C is also higher than B, then C also should be red... like that. Values should be read row-wise. How can I do this using a formula?
I am trying to color code certain rows in my data. there are only two columns a, column b. my code below will look at some row number in column 1 and look for a value "total", then again, look on the same row number, column 2 and look for value "1", then color fill it.
I have a vba script, that imports data from a sql server and queries it in excel. My question is, Could someone tell me how I could tell excel to color fill rows that if 3 different columns did not match, color the rows that the data is on ,red. ex: row1 : column b2 =5, column c2=5, column d2=6 , row1 would not be red. But if
row2 :Column b3=5 , column c3=6 , column d3=7 , row2 would be red .
Is there a way to color fill a drop down box in Excel 2003? I have a workbook where info is flilled in on the first sheet, affecting the remaining sheets. I want all areas that need input on that first sheet to be color filled in Yellow.
Trying to find a way to fill in a color based on a specified value, up to the last entry.
ie. Within a range ("Range1")T1:T9, anywhere the value is "R" , fill the color red within column P (offset -5 columns to the left) up to the last entry.
..this is something I would like to initiate via button assignment using a VBA script.
I am getting with the great user defined function (SumColor) you posted here and that I have modified a bit to suit my need. I have a spreadsheet thanks to which I calculate the total cost of a product (find spreadsheet attached below). There are three types of costs:
1. Amortization: always start with AMOXXXXX which I locate in the end of the spreadsheet
2. Assemblies: always start with a 99XXX or 98XXX
3. Components: any other notation (90, 91, 92, etc.)
Each product can have until 5 levels of subassemblies:
1. Level 0: always located in row 8 with big bold letters 2. Level1: cells in yellow (color index = 36).................
I'm using Excel 2007 and need some color help. I'm making a spreadsheet based on goals. Sheet 1 is the main sheet where every employee's progress is seen at once. Sheet 2, 3, 4 are my employee's individual pages where they log their progress. They simply fill a cell red if they've failed a goal, yellow if it's in progress, and green if they were successful.
If Jim fills cell E4 green on his individual sheet (Sheet 2), how can I make cell E4 on Sheet 1 turn green as well?
I have columns of black data that I manually go through and find regions that have cells with values that are 0.06 or more different.
I then turn these regions into blue colored regions.
Is there any way you can design a macro that goes through the spreadsheet and FILL COLOR YELLOWs a cell who is 0.06 or more less then the next cell down?
This would be so much easier on my eyes, since I usually have 80 columns and 1500 rows of data.
The blue coloring I still have to do manually because my human instinct is sometimes important there.
I would be using the FILL COLOR YELLOW cells as quick markers for my regions of interest.
Function BG(InRange As Range) Range("InRange").Select With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With End Function
That so far but not quite sure why that isnt working. I want to change the fill color with a UDF that all they do is select a Range and it changes those fill colors to whatever the Colorindex may be. I didnt find anything while searching the forums with this already.