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...
wow i cannot believe i missed that. i guess i was messing with it so much i messed up.
How about another one, what if there is another criteria it must meet?
for instance; if column b =this and column c has 123
I have notice when trying IF and =TEXT it kind of turn numbers in to garbage (see a13)