How To Use Conditional Icons To Text Column
Dec 21, 2012
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)
View 7 Replies
ADVERTISEMENT
Dec 17, 2003
I have just made my first menu using VBA code. I would like to include icons on the buttons
View 9 Replies
View Related
Feb 17, 2014
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).
File: Sales Comparison - New Outlets 2012.xlsx
View 3 Replies
View Related
Oct 19, 2013
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.
View 3 Replies
View Related
Oct 5, 2009
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.
View 5 Replies
View Related
Jul 15, 2009
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!
View 2 Replies
View Related
Sep 11, 2009
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.
View 4 Replies
View Related
Feb 19, 2008
microsoft toolbar buttons as I'm not especially artistic, but would like more choice when creating custom buttons ?
View 3 Replies
View Related
Aug 14, 2007
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.
View 2 Replies
View Related
Nov 16, 2009
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...
=if(c3<b3,"")
View 6 Replies
View Related
Oct 24, 2013
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?
View 2 Replies
View Related
Jun 5, 2007
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?
View 5 Replies
View Related
Mar 3, 2009
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).
View 9 Replies
View Related
Dec 20, 2011
I have folders with different assigned folder icons based on the content in the folders.
I would like to arrange these folders in the window based on the assigned folder icons and then by alphabetical order.
How it is to be done. Can we make use of vba having the folders path list in one column of excel sheet?
View 9 Replies
View Related
Oct 18, 2008
when the largest number in column B the hotel in column A should be in bold.
So in excel language IF(Number in B Is Max display corresponding hotel in column A as BOLD. But I can't figure out how to do this.
You can see here on the image:
additionalimage.gif
View 4 Replies
View Related
Aug 6, 2008
How do I conditionally format a cell if a particular word is within the text in that cell?
View 9 Replies
View Related
Jun 20, 2006
How do i do a conditional format where if c3 text=red then a3 text=red
View 6 Replies
View Related
Jul 30, 2009
I would like a macro that does this
1. Find the "Customer Number" column by name
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.
View 9 Replies
View Related
Jul 11, 2012
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.
View 4 Replies
View Related
Jul 11, 2009
How do you add icons into a message box. ie a warning triangle etc.
View 3 Replies
View Related
Dec 9, 2013
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.
View 8 Replies
View Related
Oct 26, 2011
Basically, I have a Rule that says:
=$A1="Mitigated"
I want the same format if Column A says either "Mitigated" or "Accepted".
I can't create a new rule as I have to save the file in 2003 for other users and I've got another 2 rules for varoius other things.
I've tried crudely putting "Mitigated"OR"Accepted" and it dosen't work.
View 2 Replies
View Related
Jun 20, 2012
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.
View 3 Replies
View Related
Oct 1, 2007
I am automating an invoice template for an excel novice, thus I want to conditionally format certain cells dependant on what text is in them.
I want to do this in VB but I don't know how!
View 9 Replies
View Related
Jan 17, 2009
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).
View 9 Replies
View Related
Sep 28, 2009
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.
View 9 Replies
View Related
Jan 9, 2009
Been hunting around the forums but cant seem to find quite what I want.
I want to specify the background of a cell to be red if the text in that cell contains a specific word.
e.g. cell a1 will have the text 'Rest of World' (without quotes). I want this to show as red if it contains the word 'of'.
Of course the cell may contain other words but this illustrates what I'm looking to achieve.
I tried the following conditional formula but this does not work:
=IF(SEARCH("of",H3)>1,1,0)
View 4 Replies
View Related
May 22, 2009
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:
View 4 Replies
View Related
Sep 16, 2009
I am trying to set some conditional formatting, but for some reason on of the conditions is not working and I was wondering if anybody know how -
View 3 Replies
View Related
Jun 6, 2013
I am working with Excel 2000
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.
View 7 Replies
View Related