Make sure A1 is the active cell in your range when you apply the conditional formatting. I think the problem is that B30 was the active cell and then you should enter the formula as =AND($A30=0;$B30-0).
It does work in OpenOffice.
I don't think so.
But it will probably get faster if you don't select cells to perform an action. For example, the last two lines of your code sample could be written as:
Range("Z9").ClearContents
If you really have A,B,C,D etc in column A (but that is probably not the case), you could use:
=MOD(CHAR(A2);2)=0 as formula for the conditional format.
Maybe there is a similar option for your real data?
I think I know understand what you are trying to do: the duration is in workdays.
Try this:
=IF(AND(Q$23>=$O26;Q$23<=WORKDAY(O26;N26-1;$HO$22:$HO$46));IF(WORKDAY(O26;N26-1;$HO$22:$HO$46)*$HI$27>Q$23;$HI$26;"");"")
It will still plot a character for the weekends/holidays, but the...
I think you want the CONCATENATE function instead of AND:
=CONCATENATE(IF(AND(Q$23>=$O26;Q$23<=$O26+$N26);IF($O26+$N26*$HI$27>Q$23;$HI$26;"");"");WORKDAY(O26;N26-1;$HO$22:$HO$46))
Cyrilz,
If I understand correctly you have a cell with a formula that gives 0 when a task is done, but sometimes the manager types a zero there if it is done before the formula says so?
If that is the case, maybe you can make the formula return a small number (0.01 for example) and format it...
> Btw you can hide the cell contents much more elegantly using custom cell format code ;;;
If you do that, you will also have to set a different number format in the CF-dialog, or the balls will stay hidden, even though they are now green!
If I understand correctly you want to sum all the differences when the value in column K is bigger than in H?
The easiest way is probably to use a helper column and first calculate the differences in column L with max(K2-H2,0) and then sum that.
I would use networkdays to get the days and an extra formula for the time.
If your dates are in column A you would get:
for the days: networkdays(A1,A2)-1
for the time: if(day(A1)=day(A2),A2-trunc(A2)-(A1-trunc(A1)),A2-trunc(A2)+1-(A1-trunc(A1)))
That is, if you want to count all 24 hours...
A bubble chart requires 3 values for each point: x, y and bubble size.
So you need to add x and y values.
The chart in the picture uses size/scale as x-values and relevance/probability as y-values. If you choose negative and positive values as is done in the chart, everything should end up in...
Dee,
To me, that error sounds like the worksheet is not present in the workbook you refer to.
Just before the line with the error, you define names for two workbooks: Ftwbook and Thiswbook. But on the line with the error you refer to ThisWorkbook. Are you referring to the correct workbook...
Here's how a one-sheet approach (as mentioned in your other thread) would work:
You have 1 sheet for data, with columns for name, date, description, amount (including +/- for debit credit)
On the summary sheet you would then use either formulas or a pivot table to summarize the date. example...