light

Hello, I have a worksheet, "Comparison" that is fed by two other worksheets. This worksheet compares two different estimates, original and new. What I would like to do is add blank cells in either A:E or J:N so that my systems numbers in cells A and J match. I don't need anything else to match...

Good afternoon everyone, I'm thinking this is an easy question but I'm having a brain fart and can't figure it out. Basically I have a spreadsheet where I need to have a red light whenever the percentage is less than -8% and a green light whenever the percentage is more than 8% and have no...

Hi, How to compare 2 list with find match and mismatch with formula. Can some help me. Sheet4 <thead> E F G H I J </thead><tbody> 1 2 #FFFF00[/URL] "]LED TRIM PANEL LIGHT 5W RD 6500K #FFFF00[/URL] , align: right"]16 #FFFF00[/URL] "]Lts Glannz Solar 1.5w Led #FFFF00[/URL] , align...

<tbody> Header1 Header2 Header3 Cat </tbody> Hello there, I currently have this code: Set CheckC = Range("B2") If Range("A2") = Value And Range("B2") = "" Then MsgBox "You cannot transfer until required information has been completed." & _ vbCrLf & vbNewLine & "Check for...

Hard to explain what I'm looking for or if it is even possible. B5 is the cell in which I have any value #.# (ex. 17.2) I have an array of data from J5 to AB5 which different values Another array from J10 to AB10 with different values and so forth Currently these arrays are not one on top of...

Hello, I have a spreadsheet with two columns, one has an area name in and the second column has the branch name. Some areas could have 5 branches and some could have 15 branches. I would like to format each row based on the area name. So if its area 1 then say a light grey, if area 2 then a...

I have an inventory of 550 emergency exit lights that must be tested every month. I'm finding my testers are not actually testing the lights but just checking them off on a printed spreadsheet. I want to install barcode stickers on the lights so they have to go to each light to verify...

Hi there, I was hoping someone can assist me in crafting a formula that would look at text and return the most frequent appearing text provided it meets certain criteria. Example data set: <colgroup><col><col><col></colgroup><tbody> Category Sub-category Data Breakfast Light Good...

Hey everyone! I have a spread sheet that comes from a 3rd party and it lists ALL the beer packages in a particular store and how many CASES of each were sold. I need a formula that will break the cases into units, but only when necessary. For example: COLUMN A...

There are several post on FREQUENCY here but I cannot seem to adapt them to my needs. I have several variables that FREQUENCY is tied to and I just cannot make them work. Any help would be greatly appreciated. ~~There are several formulas with frequency on here, but for the life of me I...

Based on odd or even value in column A want to color cells in columns B - K. If A1 is even want to color B1:K1 light green, if A1 is odd color B1:K1 darker green. If A2 is even want to color B2:K2 light green, if A2 is odd color B2:K2 darker green. Want to extend that formatting down whole...

Hi, Does any have the 'VB knowhow' to highlight a row(s) that contain a certain value? The range is c2:c200 & if it contains any of the following keywords:- base test completed OK - light green\bold base test completed failure - Light red\bold base test on test - light...

Thank You in adavnce for any help on this. I am wanting to do a loop based on the criteria in column AN. If I start my loop in cell AN2 and loop down and it comes to a cell that has the word "CLOSED". Lets use cell AN6 as an example. I then want to select A6:AK6 and AM6:AP6 and make the...

I have data with different delivery dates in another sheet. I want to do conditional formating that makes the lead time light pink if it is 2weeks pass each delivery date. I think sumifs with conditional formating could work

Hi, I have a text file(.XER), VBA can iterate through the file until it gets to this line: Screenshot(middle line) https://unsee.cc/81c0f29e/ Copied and pasted %R 190489 77906 nvirnImpaAssem/SiteWsteManagPlan�@_ It seems as though this line causes the while loop to exit. Can anyone...

HI we have some large rows of industry services and users. Basically the data is either 'Has Access' or 'No Access' and we pass this back and forth with the director as she decides and changes etc. I thought it may be helpful to have a colour a light yellow for each of the 'Has Access' since...

Is it possible to extract data from a PDF using VBA? For example, an invoice? If so, can somebody please shed any light on how this can be done? Thank you!

I have 3 rows with formulas that result in either a positive or negative percentage I want to highlight the cell in each column for the number that is closest to zero in light green

I’m trying to create a report on excel that produces a red light, yellow light, or green light (all pictures) based on if an inputted number is lower, equal to, or higher than a dynamic number (which steadily increases week after week).So far, I have been able to produce this with a static...

Good Afternoon All, I'm in need of some help on a conditional formatting issue I'm having. What I have is a employee training tracker that I need help with and I would like to use the conditional formatting tool with the green light, yellow light, and red light format. Here is an example of...