I like to mark names of persons who have done consecutively well in last two years with green circle and those who have not with red circle using Icon sets. I have created 4 columns and filled 1st with names (Text), and other 3 columns are filled with their output scores (Numbers) over last three years (2010-12). Like to highlight those names who have done well in last two years (2011-12) as compared to the third year (2010).
For example:
Names Score 2012 Score 2011 Score 2010
John 168 153 144 (should mark with green circle)
Steve 201 182 181 (should mark with green circle)
Mary 98 102 110 (should mark with red circle)
Is there any method to change the placement of conditional formatting icons. By default, the icons appear at leftmost part of the cell. Is there any way the icons appear at the centre with percentages (see attachment).
I am trying to apply a conditional format to an entire row based on the presence of any value in the first cell of that row to format to a certain color. If there isn't something present in the first cell, I don't want it to change.
Everything I keep trying ends up highlighting the entire workbook.
I would like to apply the rule to the entire sheet but only have it highlight the rows which have a value/text in the first cell of each row.
I am assuming I should use the formulas selection for conditional formatting but I'm unsure of what formula would apply to this type of request.
I am trying to write a macro to search a column for a specific text string which when found, will copy the whole row the string is in. Once this row has been copied, I then want the macro to activate a new sheet and search for the next available empty row to paste the data. Once this has been done, go back to the original sheet and find the next cell in the original column with the specified text string and repeat until the range has been satisfied. Below is the script I have that sort of works.
I have been using Excel for some time now but just started working back with the Macros! Finally figured out that you had to turn on the Designer tab to get to some of the functionality of the macros. I havent been able to find ANYTHING ANYWHERE to tell me how to create buttons or Icons in the 07 Excel!
I want to transfer my Excel-icons. Some of them are custom buttons where I have added user-defined functions. Is there any way I can do this? A list of icons with their function or purpose is OK as well.
I've just finished writing some vb code that i need to assign to a button. Trouble is I select the control toolbox and put it design mode and all of the icons with the tool box are greyed out. pic attached below
pukks Auto Merged Post;Doh Doh and double doh!
Problem solved: I inadvertently had selected more than one worksheet tab and this was stopping me from placing a button on the worksheet.
I'm trying to create a formula where I can show the trend of two values from one month to the next that shows wheather the results went up or down in a positive or negetive value. For example:
If I have a transfer % of 18% in October and November MTD is at 17% - the arrow would then reflect downward showing in green, as the lower percentage is better. but I need the arrow to show upward in Red if say the value for November MTD was 19% instead.
I tried conditional formatting and attempted an "If" formula. I must not have all the information to create the formula as it errors out on me. I can create it if only looking to reflect one arrow...
I've created some macros in Excel 2010 which I've added to the Quick Access Toolbar and want to show them using some of my own icons rather than the ones that show when you click the 'Browse' button. There is no option to navigate to any other location.
Is it possible to access icons other than the set provided?
When adding functions to the quick access toolbars in Excel 2007 sometime they do not have an associated icon with the function. The icon shows as a green circle. How to change the icons and also to have a selection of icons like you have had in previous versions of Excel?
I ran a simple macro that I created in my workbook, got a run-time error, clicked debug, clicked reset to stop the macro running, and now all of the icons in my workbook are greyed out. I can select cells, change worksheets, enter information in cells etc....just I can't save the workbook, or select any of the icons on my ribbon / in the office menu. Would really like to avoid terminating the application as I made a number of changes that I didn't save (doh doh doh).
2. Find the range of the "Customer Number" column (bottom-most cell with data)
3. Find the column named "Date Shipped"
4. If there are any NON-Blank cells in the column named "Date Shipped", put the word "Sent" in the "Status" column (also needs to be found by name). This macro should stop when it is equal to the bottom-most cell in the "Customer Number" column.
Writing a UDF for VBA as I'm getting frustrated by the concatenate function.
I basically want to create my own function that will concatenate values in column B, if the value in column A is correct.
I've been looking at this link [URL] ......
With a very simple data set as an example, I want the following output in column C:
pet food conc
cat chicken chicken,fish,catnip
[Code] ........
I think I need to create a cell based function which takes a conditional range (col A) and concatenate range (col B) as inputs, stores this as a 5 by 3 array and then returns the concatenated output I wish (by referencing the stored array) based on what value is in column A. A "concatenate if", if you like.
is there a way to have a cell display a certain text if it is empty?
i.e. i would like all the blank rows in a section of my spreadsheet to have a grey fill and display the text "Please input your description here" if the cell is blank.
Right now I have this working to color a row green if Column A contains the word "Open", I just need to add to this to say Column a="Open' and Column H="Red"
How do I do this? This is what I current have
=$A6="Open" (I need to add that if $H6="Red" as well)
How do I fix the syntax formula that will achieve this.
I would like to calculate the mode of a range of cells containing text. To do this I would use a formula like:
A red yellow orange orange blue orange yellow
=index(A1:A7,mode(match(A1:A7,A1:A7,0))) (orange)
How do I find the mode of a range of cells containing text with an additional criteria, like finding the mode of A only for values with a "yes" in B as in: A B red no yellow yes orange no orange no blue yes orange no yellow yes
In this case, the answer I'm looking for would be (yellow).
I would like to conditional format a range of sells which contains numbers formatted as text. I would like if the sell contains the specific number (which is formatted as text) to be formatted in red. It works for one value but I have to list 15 values for which this condition to be done. For example: if some of the cells in the worksheet contains one of the following values: 265987,265489,235698,2356987,2356987,2356987,235569,...ets - 15 conditions - to turns red.
This is an continuation to some earlier formulations to place value correctly in cells. It started for me here: http://www.excelforum.com/excel-gene...ell-value.html
Now, I've come across another situaton. If there is a value of any combination of numerals and text "X" specifically as: 1x,21x,100x,1001x,10230x, I'd like to have the x removed. The resultant will be in column D of sheet FormulaOut. See attachment as this will be building on the following formula:
If cell D4 has a 90 or above, I want cell C4 to highlight in green, but I also want the cell to display the word green. I know how to do the former, but the latter perplexes me a bit.
