Search results

How do I get the proper difference Cell B1 '=SUM(B2-A2) = 226,789.34 But the true answer should be 2754.86 Cell A2 has a negative number -112,017.24 / Cell B2 has a positive number 114,772.10 How do I get the proper amount of 2754.86

Having problem getting the code to work to create a dark bottom border on cells I select; The Range will only process in the "A1105:G1105" row of my sheet. I want it to work on whatever Row/Cell(s) I select. >>> use code - tags <<< 'Sub DarkUnderscore() ' ' DarkUnderscore Macro ' create dark...

Can the below formula be put in VBA? I use it in a table and sometimes the formula gets accidentally messed up which causes a problem I also have to copy & paste the A? cell to hard code the number left after the date in C5 is entered. I have the formula in A5 and as lines are added it changes...

New to VBA and I cannot seem to get this to work. i am pretty sure it has to do with the first line If i enter something in column C i want it to put the date in D. Also when I change column F to 'Closed' I want it to put a date in G. >>> use code - tags <<< Private Sub...

All great Excel Ninjas, Need help fixing this conditional format. Seems I can only get the column to highlight the letters in 'Red' that meet a certain criteria. Column B is not a Boolean search it is only the results of an output using a powershell script. How do I get it to highlight the...

What formula would I use to highlight only those rows that contain abc? I have tried =$c2=”abc” I also tried Search and Find but they didn’t work either. column a column b column c FALSE TRUE abc.def.ghi.jkl FALSE TRUE 123.456.789.012 FALSE TRUE xyz.abc.def.ghi FALSE TRUE...

What happen to the search function on www.Chandoo.org/wp I tried to search for something but the search function is gone.

How do can I make this add 8 for every 'a' it finds? =COUNTIF(E10:P10,"a")

I wrote a formula to count a column only if it meets the right dates but all I get is a 0 zero formula =COUNTIFS(Sheet1!I:I,">="&Sheet2!$D$2,sheet1!H:H,"<="&sheet2!$G$2) I need to count I if it falls between the dates in H the dates are entered on sheet 2 cells d2 and g2 my formula above...

Is there a way to have multiple but specific dropdowns? Column A has a series of letters A-Z for one dropdown. Column B has a series of numbers for a dropdown. Col A Col B A 1.1, 1.2, 1.3, 1.4 Choices B 2.1, 2.2, 2.3, 2.4 Choices C...

a b c. D 1. 423 447 95% 94.63% 2. 244 245 100% 99.59% 3. 179 179 100% 100.00% As you can see above 2C is rouned up. If I set cond fmt to set the color to green for those at 100% it only works for 3c not 2c. And if I use the...

is there a way to use Conditional Format to tell you you are missing a specific amount of Characters? Example: You have a cell the will contain Numeric.Alpha (0123456789.A). does not matter what the value is except (10 numbers.1 Character) only, no more no less. Ths

Using LEN you can count characters in a cell. if you have a range of cells that must have 12 characters always in each cell, how can you use the LEN command with a conditional format if less than 12 characters exist in a cell?

All, how would you write a formula to count the quantity of how many times a particular date on a different Tab. i have this but can't seem to get it to work =VLOOKUP(FirstTab!$A1,(=COUNTIF(SecondTab!$K:$K,"4/27/2012"))) Too few Arguments

I just tried to use the conditional formatting that Chandoo sent out for my problem below but I could not get it to work. Lets say you wanted to set a conditional format for dates from 10 months then 11 months the expired after the 365 days or 1 year from now? So if the date is set to 1 June...

is there a way when using VLOOKUP to throw in conditional formatting? example if i have a lookup and it finds the item is there a way to color code that item that it found?

All, Let me set this up first. I have a table that is 434 rows long and columns A-AJ. It is set up with a few conditional formats (no data=Red), and one simple formula. Here is my problem; I have to update this spreadsheet once a week from an export downloaded from a web site. The process I...

All, how can a place a conditional format on a column? I have a column that monitors a dates, if the date is over 365 days the condition would be to change the cell to red

Having an issue with sum and subtotal or not sure if i should be using either; a b c d 1 Cost qty sub-total total 2 1.00 1 15 15.00 the problem is when i change b1 it also changes c2 and d2 to whatever number i put. i need it to add the qty to c2 then add the amount to d2 So if i put...

Is there sometimes something wrong with using D as a variable? The formula works great for other letters I'm using except D I even used find and replace to replace all of the D's to DD or Team D and it found and replaced 36 D's. Then of course adjust the formula but then the formula only...

Chandoo I am a begineer and love your site and ExcelUser. I have 2 questions regarding COUNTIFS and what would be the best formula to use? First, I cannot seem to get COUNTIFS to work. I get no error but it returns a 0. I used the Help file and Google but can't seem to get it to work for...

how do you get a worksheet to only display say columns A-Z and Row 1-50?