I have a spreadsheet that has values in the end column that read Addition, Deletion or No Change. I am trying to get the row cells in Column A to shade red, green or yellow depending on the value of the cells in Column I. I have tried the folllowing:
="IF(I4=No Change)"
I chose the fill to be green for this but when I click OK nothing happens but I do not get any error messages.
I have a spreadsheet that i am tracking some Training dates on. i have the requirements written in the box categorgy on the attachement if anyone wants to see it. Ok so so far in the B colum (contains date of a computer based training (CBT))i have this conditional formatting: Formats for Red background
View 2 Replies View RelatedIf a1=today and b1=null then colour of cell should be green, or If a1=today and b1between today and +7days then colour of cell should be yellow
If a1=today and b1 between today and +14 days then colour of cell should be green
I am trying to do this in conditional formatting, but it doesnt work. As when we try copy to all cells the ref is still for B1 so it wont work on a spreadhseet with many data rows.
I have set up a basic sheet for a colleague, whereby the Team Leader can enter client names into a control sheet, and then the team can add the client names into the allocations sheet when they take on the care for that client, and Conditional Formatting colour codes the cells to show which program a client comes under.
My problem is, the conditional formatting works perfectly on my computer, and another colleague's computer, but for two other colleagues, only half of the colour coding works... leaving half of the clients cells white, indicating they are not allocated to a program.
I have checked that we are all using the same network pathway, macro security settings etc.
I am trying to do a conditional formatting for the number of working days. What I am trying to do is:
Example:
As in the row D7 I give the actual workdays required to finish the task the Gantt Chart gets a specific formatting on the right appears for the number of working days.
Problem:
I want to avoid the formatting if there are any weekend (Saturday or sunday)
Suppose I give number of working days as 20 then there would be 6 weekend days so it shall add to the overall actual working days but again sinnce we are adding 6 additional days one more weekend day would come in between so the formatting shall take care of this.
I have a spreadsheet which uses conditional formatting to highlight cells with certain values. It's works perfectly, except for a single cell. The formatting formula is and should be exactly the same as other cells in the sheet. For whatever reason, this cell will not change with the formatting rules. The cell is not protected, it doesn't have any oddball values or anything that I can see.
View 3 Replies View RelatedI have a conditional formula that highlights dates red when it meets a certain criteria. The file named MS Working, the conditional formatting formula (formula below) works as it should with no issues. The other file MS NOT Working, the conditional formatting formula (formula below) has stopped working as it should. What I did? I inserted a new column to the left. Where the MS Working file has only 1 column to the far left, the MS NOT Working file now has 2 columns to the far left.
It seems as if the formula adjusted itself when I inserted the new column; however, its not working.
MS Working
Conditional Formula: =AND(TODAY()>B3,NOT(ISODD(COLUMN())),B3<>"",OR(C3="",C3=0),B3<>0)
MS NOT Working
Conditional Formula: =AND(TODAY()>C3,NOT(ISODD(COLUMN())),C3<>"",OR(D3="",D3=0),C3<>0)
I have created a spreadsheet that will show me where people are working on what day, etc. however i want to be able to filter by week to create a list of say 2 particuar shifts - in this case "syl ld" and syl n so that the spreadheet would show the people who are working these shifts and I could print out. I have tried Multiple Filters and Advanced search but cannot achieve what I require
View 3 Replies View RelatedExcel 2003
On one of our computers at work, Excel is acting especially strange. The conditional formatting in Excel on one of our computers is not working. In addition, we cannot fill a cell with any color or change the color of the writing. We can click a color for the letters and type it in, but immediately after another cell is highlighted, the writing goes black again. When we try to highlight multiple cells with the cursor, the cells are black instead of the normal color. This happens to not just spreadsheets that are new, but existing spreadsheets on our shared drive from only this one computer as well. No other computers are affected this way. All other computers show the spreadsheets fine and do not have any functionality issues.
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 RelatedI have a button on a userform that will generate certain text in a combo box. The combobox then goes to a worksheet. If I select a second button, I want the first information on the worksheet to clear and accept the new information from the next button.
NOTE: I have it as a combobox so I can either select it from the combobox or click the button. When I select the information from the combobox, it does clear out everything automatically.
Here is my code:
Private Sub CommandButton2_Click()
Worksheets("score").Range("B6").ClearContents
ComboBox1.Text = ComboBox1.Text + "PASS"
Worksheets("score").Range("b6") = Me.ComboBox1.Value
TextBox2.SetFocus
End Sub
What I think I am doing is clearing the cell, entering my text then going to the next text box, but when I click the second button (same code, text is "FAIL"), I then get "PASSFAIL" in cell B6.
I want it to clear out the previous entry and only use the new one, but it keeps all that I click even though I said to clear the contents.
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
The Code will not add the found values into the userform textboxe's.
View 14 Replies View RelatedI have an xls-workbook that is saved in OpenOffice. It has simple formulas that shows correctly in Excel. Excel doesn't solve them before "re-accepting" (like going to formula bar and pressing enter). No editing of formula is needed at all (unless you count "enabling edit-mode" and accepting the empty edit as editing).
View 2 Replies View RelatedIs 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???
Leith Ross kindly helped me with the below macro but for some odd reason, Excel simply does'nt like it and gives me the error message: "Compile Error: Object Required".
The code below is part of a bigger macro.
I've created a worksheet that uses multiple print macros with defined margins. This works fine with the Epson printers I have, but a user has an HP Officejet Pro K550.
This printer has an option named "Minimize Margins". If this option is checked then you adjust the margins the way you want.
For some reason when this particular workbook is opened you have to manually go and check this option so that the margins can be manipulated. this is a problem b/c my macro prints several reports so it's impossible to set this option.
I then opened a different workbook and it accepted the default setting (option checked). For some reason the workbook I created doesn't.
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.
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 RelatedThis code is not accepting the values which is starting from strings like this
for example
bearing 15/16 IN LG, 1-1/16 IN OD, 11/32 IN THK,21/128 IN ID
19/128 IN LG, 2-3/64 IN OD, 1/2 IN THK, 5/64 IN ID
steel 15/16 IN LG, 1-1/16 IN OD, 11/32 IN THK,21/128 IN ID
19/128 IN LG, 2-3/64 IN OD, 1/2 IN THK, 5/64 IN ID
spares 15/16 IN LG, 1-1/16 IN OD, 11/32 IN THK,21/128 IN ID
[Code] .....
I have a conditional format that I wanted to add another argument to, but although the statement is true, conditional format will not toggle.
My original argument was:
I have the macro below that I want to use to conditionally delete all columns where the first row of each column does NOT have the following values but it seems to be deleting most of these columns as well all the others.
Fellow Excellor
Sub Deletecolums_Conditional()
Application.ScreenUpdating = False
[Code]....
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 RelatedThe following code worked for me until,I put inside a list box.
View 4 Replies View RelatedI use a scanner that initiates a f2 command and trips my macro. I would like to use multiple scanners using a 8 port hub but I am having trouble with a scanner starting my macro and another scanner dumping data into my macro before the first one is finished. This is dropping scanned data into my macros. Is there a way to prevent the scan from accepting data until the macro has completed its cycle.
View 2 Replies View RelatedIn 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
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 RelatedI seem to have a problem using conditional formatting with Vba in Excel 2003
When I run -
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 RelatedI 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?