turn

Hey everyone. Just wanted to started saying off by thanks! This forum has been invaluable whenever I am looking for solutions to problems. This time though, I'm having trouble finding a good solution. I have some poorly formatted data that I would like to be able to index, so I am trying to...

Hi All - I wrote a sub that copies certain formulas from one workbook to another blank workbook. I've set Application.EnableEvents to false - this seems to work fine if I'm copying code to another sheet in the same workbook, but if I'm copying to another workbook, events are triggered and I...

Greetings, I have a number of scraper like subs that I would like to automate. for this task I am using a number of subs to serve as the timing tool like the one below: Sub YZ_ST19() RW19 = Now + TimeSerial(744, 0, 0) Application.OnTime EarliestTime:=RW19, Procedure:=RWCALL19, _...

Is there a way I could setup conditional formatting for company names in cells A6:A493 to turn green if they are listed in any of the names in cells D6:D120? Thanks

Hi, I have a task where I copy/paste text from various sources (that cannot be changed) into a single workbook that I then use to upload to Access. I've set up some autocorrects to changed the text into the format I want, but it's a long process clicking on every cell in turn. Does anyone...

HI all something which shouldnt be difficult but is alluding me Excel sheet A B C D E 1 C001 100 10 0 1000 2 C004 150 15 80 8000 3 C005 203 100 200 50 4...

Hi I am using the following rules in Conditional formatting format Only Cells that Contain 1. Cell Value Greater than =206 will turn RED 2. Cell Value Less than or equal to =205 will turn GREEN now if i have nothing in the range the Cell is still RED....how do i...

Hi everyone! I have a column of cells that is for peoples names (column C). I have three more columns on th3 table that are for entering numbers (columns F, H and J). If that person is absent that day, I want to manually turn the cell with their name in it RED(cell C2) and then when I do that...

Hi Everyone, I have a big problem with duplicates and I'm trying to get it sorted out. however I'd like a warning message box to tell me when one has been identified. currently I use conditional formatting to turn the cell red if its a duplicate. but I don't go to the tab very often and it...

Hi everyone. I have two issues that I think a lot of you would be able to help with. Issue#1: Conditional Formatting I have 3 cells in different location in the same row that need to be conditionally formatted. Each of the three cells already have a formula in them. End state, I want the...

Found a lot of hits on Google, but they all say go to Oprions, or Ribbon etc, How can you turn them off in VBA please ?

Is there a formula where: There is a drop down menu in column A, let's say the menu is Earrings, Necklace, and Rings. And depending on what the user selects, (Rings) I want column B to turn red. Once they enter in their ring size in column B (not a selection, they type it in) I want that cell...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would like to prepare a VBA code so that to run through row “2” and where find blank column, should turn the section’s data below of the previous one with one blank...

Guys, Is it possible to turn off a a specific part of the condition formatting? For example, range $H$2:$NH$27 Contains the following: When the Cell value contains 'sick' then change the background yellow and font black. So bascially i would like to have a button that i can click to turn...

Hi, I am having issues with some conditional formatting. I am wanting cells to look at a value of the cell next to it, and if it is higher than that cell turn green, if its less than that amount then turn red. Simple!Apparently not! Column A contains the value I type in that I want to change...

Have this: A1=val A2=val A3=val A4=val A5=val A6=val A7=val A8=val Need to turn next column into this: B1=A1 B2=A1 B3=A2 B4=A2 B5=A3 B6=A3 Excel won't pick up on the pattern, any tips? Basically need to turn "X" number of cells into twice as many cells, duplicating each cell below itself or...

Hi, I am using Excel 2010. I am trying to get conditional formatting to colour a cell red if there is 2 or more or 2 less between two cells. ie L leg cell Z6 and R leg cell AB6: if L=3 and R=4 Both cells Z6 and AB6 stay clear. if L=2 and R=4 both cells Z6 and AB6 should turn red. if L=1 and...

Hi I’m looking for VBA code to turn off the screen refreshing on key values in cube functions. I have a large Excel spreadsheet with many tabs and it takes 20 minutes for the system to refresh the information from our SQL Server database. I was thinking if I turn off the screen refreshing of the...

Hello, I'm hoping you could help me out with an urgent query. I'm about to launch a new range of 8 products which in turn have 6 possible options - how can I calculate the total amounts of combinations for every product? Thanks in advance for your help. Jan

I'm trying to apply conditional formatting into columns with dates into date fields that show red yellow andgreen; if not complete AND date not passed = green; if not complete and date1-10 days late yellow; if not complete and 11+ days late = Red For example, if column A has a date of...