Conditional Formatting - Icon Sets According To Value % Does Not Execute?
May 9, 2014
I'm trying to insert a simple conditional formatting rule - icon sets according to rule percentages I've selected (Green > 90%; Yellow < 90% but > 80%; < 80% red). The conditional formatting does not work once i select okay. For example. The data set shows 95% as red, 83% as red, it's just not working for me. I've tried opening a new workbook, new worksheet and nothing seems to work. I've been able to do insert this rule based on "number" setting but unsuccessful with percentages.
View 2 Replies
ADVERTISEMENT
May 30, 2014
I am looking to show Month Wise Trend Up/Down/Nuetral Arrows for the Achievement % for each month.
I want to show the Increase or Decrease trend of the % in the next month.
I have Baseline figures (count) and i have count of Mar, Apr, May months. (Column A)
I have calculated the Achievement % by 100%-(Actual/Target) (Column D, G, J for Mar, Apr, May Months)
I want to show the Increase or Decrease Trend Up/Down/Nuetral buttons either by the Achievement % or by the Total Incidents Each month compared to the Baseline Figures (Column A).
I tried to use Icons Set in Conditional Formatting but i was not able to do that.
Sample file attached : Sample.xlsx
View 2 Replies
View Related
May 23, 2014
Is it possible to change color for arrows icons in CF- icon sets? I would really like to have a five arrows pointing in different directions (all in different colors).
Can I do it in conditional formatting or should I go for "Wingdings" fonts and then change font color?
View 2 Replies
View Related
Mar 26, 2010
Any way to import and use icon sets for conditional formatting other than the ones provided in excel 2007? I would like to have some circles and shapes in colors other than just yellow, green, red, and gray.
View 5 Replies
View Related
Mar 20, 2014
I am trying to apply icon conditional formatting in a cell. The cell contains the following formula: =VLOOKUP(D20,'owssvr(1)'!O:W,9,FALSE The formula results in a "2", "1", "0" or "-1" in the cell. The icon conditional formatting is not working at all (no icon appears). I have the conditional formatting setup as numbers Green 2, Yellow 1,0 etc based on value. If I delete the formula and just type in any of those numbers directly, it works. I have changed my cells to "number" and it still does not work.
View 3 Replies
View Related
Jun 4, 2013
I want to display icon sets in Excel 2007 (arrow) based on prior values. If value is less then previous cell then down arrow should be displayed else up arrow.
View 1 Replies
View Related
Dec 13, 2012
I've been using conditional formatting for some times now, but this is the first time I have this problem..
I've using conditional formatting to display icon besides a sets of numbers/percentage. The condition is as follows:
--- >= 75, green
--- >= 60, yellow
--- < 60, red
When I used this for "number", it works flawlessly.
But when it comes to "percentage", disaster strikes.. I am getting a Yellow for 75%, and red for 60%.
Below is a screen shot that I did to illustrate the issues. The set of numbers on the left is OK. But the same set on the right, just in percentage, doesn't work well..
View 2 Replies
View Related
Jul 8, 2008
I have a few rather large spreadsheets full of addresses, but for simplicity I'll refer to two(Group A, Group B). I can go back and edit accordingly. Group A is a master list of users. After sending out a mass message, using Group A, certain users weren't able to receive the message for various reasons (address problems, spam filters, etc.)--thus Group B. All of the users of Group B are still in the Group A spreadsheet, and this is where my problem comes in.
I need to take all of the entries from Group B, find them in Group A and change their cell colors (along with a few following cells in the same row). I tried to record a macro to do this, but found that a more in depth solution was required. I tried to implement some VBA but my knowledge is, at best, limited.
Here's what I've done so far:
Before recording the macro I copied/pasted the addresses from Group B onto the bottom (a few cells down) of Group A.
I copied the first Group B address, started to record, and pasted the first address into the Find tool. After it was found, I changed the color of the needed cells, went back to the list of Group B cells and deleted the top entry. Next, I copied the second entry (the new first entry) and stopped recording.
When I pressed the shortcut key for the macro, it deleted all the cells correctly; it just didn't format Group A like I intended. I then opened up the VBA editor within excel and found this:
Sub Colorfill()
Range("A4559").Select
Selection.Copy
Cells.Find(What:="USERADDRESS", After:=ActiveCell, LookIn:=xlFormulas _
, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
Range("A2038:I2038").Select
With Selection.Interior
.ColorIndex = 43
.Pattern = xlSolid
End With
ActiveWindow.ScrollRow = 4349
ActiveWindow.SmallScroll Down:=186
ActiveWindow.LargeScroll Down:=-2
ActiveWindow.ScrollRow = 1508
ActiveWindow.SmallScroll Down:=198
ActiveWindow.ScrollRow = 4569
ActiveWindow.SmallScroll Down:=-27
Rows("4559:4559").Select
Selection.Delete Shift:=xlUp
End Sub
View 9 Replies
View Related
Aug 20, 2014
I need to send out an order form (spreadsheet) to 100's of people that need to complete the form and email back to me as an attachment. If I was completing the order form myself I would use the "email" icon that I have pinned to my Quick Access Toolbar (QAT). However, most of the recipients don't even know the Toolbar exists.
Is there a way I can insert an icon / hyperlink in the spreadsheet that does the same thing as the QAT icon. I can insert text to say "click here to email your order" (or similar).
I need to keep it in an excel format and an icon is so much better that asking them to save to their hard-drive and attach to an email, etc.
The QAT icon is exactly what is needed but I need to provide a spreadsheet that works for folk who haven't got the icon.
View 4 Replies
View Related
Feb 28, 2014
I have the following code:
[Code] .......
What do I need to change in order to make it execute the Call statement on EVERY item in the ListBox2, not the Selections.
View 3 Replies
View Related
Apr 10, 2008
Below is a series of sets. Column A is the set number. I need a macro that will insert a row between sets and then put a border around each set. In my spreadsheet the sets are from A1:C500. Sometimes the sets are only 1 row, sometimes multiple rows. It looks like I will be doing one of these sheets every week. So far I have been doing it manually, but a macro sure would save some time.
View 13 Replies
View Related
Sep 16, 2013
A little background on what i am doing. I have a spreadsheet that tracks when i have blown the dust out of our computers. I have set up conditional formatting so that the text turns red after 300 days and the cell turns yellow after 600 days. However, some computers are in high dust environments. I would like the spreadsheet to tell me to blow the dust out of these sooner. see the attached sheet.
dust 1.xlsx
View 2 Replies
View Related
Mar 20, 2013
Is it possible to change the format of cell AI3 based on the format of cell C3 and D3? I have C3 and D3 set to turn red based on what is in cell C2 and D2. I would like the following done:
If AI3=C3 & C3 is red, format AI3 blue
If AI3=D3 & D3 is red, format AI3 blue
Otherwise, leave AI3 unformatted.
Possible???
View 3 Replies
View Related
May 5, 2009
Is there "code" for different formatting in a spreadsheet so you can use an IF statement to do something like:
if(A1=blue background,"Yes","No")
or
if(A1=red text,"Yes","No")
etc.?? But replace "blue background" and "red text" with some sort of number code? I want to compile a list of the items that are formatted with certain background colors and/or text colors and then organize only those items into a chart.
View 5 Replies
View Related
Jul 5, 2013
Any VBA that I can put into a macro that will convert conditional formatting into fixed formatting..? So when the cell contents/formulas are deleted the formatting remains. Assume that the range I want to convert is A1:D200...
View 9 Replies
View Related
Feb 9, 2009
I need to run a loop through a column of values (attachment col B) and when it finds a "J" it will apply conditional formatting to a row of 4 cells directly adjacent. The attachment is a theoretical before & after.
View 2 Replies
View Related
Dec 9, 2008
In a column, there are 4 option for each cell -
"PAYMENT DUE"
"PAID"
"UNDERPAID BY..."
'OVERPAID BY..."
These are filled in by a formula
I would like to make them 4 different colours but excel only allows 3 options
View 14 Replies
View Related
Mar 5, 2009
I have a hard time when it comes to "If then" statements and conditional formatting. I have some data that I am collecting and entering into a spreadsheet for a couple different companies. Once I receive paperwork from those companies for the data collected I mark the data with a blue colored text. I would like to have a second sheet that generates what companies have not sent me their paperwork. "If the data is black text, then generate <name of company> on second sheet." The list is small right now, but as the project continues it will grow very large and it will become difficult to track. I will attach a copy of the spreadsheet for you to see the situation. I would like to learn how to do these types of formulas, is there a tutorial geared towards these types of situations?
View 2 Replies
View Related
Dec 23, 2009
I seem to have a problem using conditional formatting with Vba in Excel 2003
When I run -
View 3 Replies
View Related
Nov 11, 2009
Must admit the R1C1 still confuses me, but somehow I have this working. Currently the RC4 displays in conditional format as $D8 and the RC4 as $C8, but I'm confused at how it knows to start at R8? Is there any way to make the formulas read ="=$D8=""No""" instead?
View 2 Replies
View Related
Feb 3, 2010
I have two spreadsheet "book1" with data in it, "book2" that takes all the information from "book1" the cells are linked in "book2" from "book1" so when someone updates "book1" the information is viewable in "book2"
In "book2" where I am getting stuck is as follows,
Column A contains data "break time" that is formatted in HH:MM:SS column B contains a "total duration" in HH:MM:SS. what I need to do is if column A data is = to or more than 4% of column B then I want to turn the cell in column A "red" if it is less then turn it "green". I have tried conditional formatting and it appears to work the once only, I dont no if this is because its 2003 and not 2007??
What I need is to repeat the conditional format over and over again forever is there any code for this I can use?
View 9 Replies
View Related
Oct 31, 2008
I have used conditional formatting various ways to format an individual cell. I was wondering does anyone know if it is possible to conditionally format a row? Eaxmple: If D7=Manager, then format A7 through Z7. If so, how would I go about setting that up?
View 3 Replies
View Related
Dec 15, 2009
I'm wanting to create a formula in column B that will return a value of 10 if column A is any value between 70% -100%, will return a value of 5 if column A is any value between 50% - 69%, and will return a value of 1 if column A is any value between 1% - 49%. Can you help me?
View 6 Replies
View Related
Oct 29, 2013
I want to do an if (I think I do??) command so that if a1=b1, then the cell turns blue and if a1=0, the cell turns red, with the false statement just being blank.
View 3 Replies
View Related
Apr 21, 2014
I have data in column B.
And if the below mentioned values are present in column "B" then the cell colour should change to "RED Colour"
Bombay
Mumbai
Bangalore
if any other values other than the above mentioned then the cell format should remain as is.
View 1 Replies
View Related
Jun 11, 2008
I have my formulas in place and they are working. The reason why some are coming up with #DIV/0 is because I do not have the data to complete the calculation.
Is there a way to make the #DIV/0 error go away until I imput the data to complete the calculation? I was thinking there might be a way to do it with conditional formatting.
View 9 Replies
View Related
Jun 30, 2008
Sub Macro1()
With Range("A1")
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="=A1=B1"
.FormatConditions(1).Interior.ColorIndex = 3
.FormatConditions.Add Type:=xlExpression, Formula1:="=A1B1"
.FormatConditions(2).Interior.ColorIndex = 50
.AutoFill Destination:=Range("A1:A29"), Type:=xlFillDefault
End With
End Sub
If my active cell is NOT A1, the formula entered into conditional formatting is off. The range references get all messed up. For example, if my active cell is Say D5
Condition 1 is
=IT65533=IU65533
Condition 2 is
=IT65533IU65533
But if I run the code with A1 as my active cell, it gets entered correctly as
Condition 1
=A1=B1
Condition 2
=A1B1
View 9 Replies
View Related
Jul 18, 2008
I would like to add conditional formatting for the whole row based on whether the value of cells in column A is "CON".
For Each c In r
If c.Value = "CON" Then
c.EntireRow.FormatConditions.Delete
c.EntireRow.FormatConditions.Add Type:=xlExpression, Formula1:=c.Address = "OK"
c.EntireRow.FormatConditions(1).Interior.ColorIndex = 35
end if
next c
the "CON" is a formula and can later take the value "OK".
The conditional formatting should highlight the whole row as green when that happens.
View 9 Replies
View Related
Feb 25, 2009
I am not sure if this requires conditional formatting/vba function
If I enter something in cell A1 and leave blank in cell c1, in cell c1 it should print the message "Required Entry, Please Fill up". and this condition should be applied to entire column, where ever in column A there is some values and column c is empty this condition should apply.
View 9 Replies
View Related
Apr 27, 2006
I don’t know if it is possible in Excel 2000 but I have a simple IF formula in a cell that gives "" on certain conditions.The problem I have is that in another cell I apply conditional formatting – green >100%, red<100% e.g.
Is it possible to have a third conditional format that gives a blank if the cell is ""?
At the moment it just turns out green as it doesn’t seem to recognise the cell as actually been blank as it has a formula within it.I have tried ISBLANK etc.
View 3 Replies
View Related
