if and then function

I am trying to build a spreadsheet that has multiple condition. When I plug in my conditions into conditional formatting, it won't work. 1st condition: I want 3 rows to be filled in blue, with border and vertical lines highlighted, one line no fill/border, then the next 3 rows to be no fill...

Hello, I'm looking for a formula that would turn a cell a certain color (the intricate part is I need it to read a code from another formula where the name that will be placed which will be in a different spot everyday will look up a certain code like AA. If the name does not have an AA beside...

I have a column with employee names, and a column with hours they worked. There's a list of names, and next to the list I want it the result to be the total added hours for each name. Can you help? In the example, Column D (Total Hours per Employee) is where I wish the formula to be: <tbody>...

I am creating a summary, where I want to count a number of occurences (e.g., Pass, Fail, etc.) according to multiple combinations of criteria in other columns. My problem is with getting the multiple combinations. My formula is getting monstrous and by my logic this might go a lot longer...

Hi, I am trying to sort through two workbooks (two sheets) Workbook 1 contains info on dates, parts, & qty ..etc.. Workbook 2 contains the same.... I am trying to match the info to find any discrepancies with the data ex: dates are off by greater than 30 days, qty is way off (1 vs 10). I run...

All, I am really a newbie in Visual Basic and looking for a code to do the following: I have a massive sheet in which the first column is the ID number of a product. The ID number can be a 'parent' ID, but also a 'child' or 'grand child' ID, which refer to sub products of the parent product...

Hi there, I am reposting this again as I did not get a answer that worked on the previous post and I thing it went dead. I need VBA code for: If Range(F2)greater or equal to 90000 and (H2) = 90000 the (J2) ="Gold' else if (F2) = smaller than 90000 but greater or equl to 70000 and H2 =...