Search:

I have a xml file created by the application:
<Post>PC 21000 Split</Post>
<Date_Of_Delivery>12.5.2016</Date_Of_Delivery>
<Card>S</Card>
<Number>I</Number>
<For>21276 Vrgorac</For>
<PP1></PP1>...

Thanks for the interest, but I have attached a file that is not protected. In the meantime, I have found a solution, the key is in the ActiveX Combobox's Linked cell (ACB Properties), and then on the...

I have a macro that change checkbox caption font color when checkbox is checked. How conditional formatting cells C2,D2 AND B3 in same manner.

See in attachment what happens with Randomly songs if conditional formatting changed to:

=MOD(Q$14;4)=3
=MOD(Q$14;4)=2

What is wrong?

In the example you sent me are two conditional formatting rules:

=MOD(Q$14;4)=0
=MOD(Q$14;4)=3

and everything works OK.

I need for different shift to change these rules to:
...

No, not in the same workbook.

These are the four sihts with different workdays in different workbook. Select Q15 and change Conditional formatting rules, for green filled fields to...

If you do not take away too much time, praying for one more service:

In the example you have done, the conditional formatting is: =MOD(Q$14;4)=0 and =MOD(Q$14;4)=3.

How do I get this same...

I never doubted your ability and willingness to help me.

Very, Very thanks!

Sorry, example "results" for April in Attachment.

View Attachment!
When you change the month or year in BF1 or BF2, the table is changing yellow and green fields that show my siht. Sunday is not a business day. I need macro that will in each...

How to increase values in column E by 1 every day starting with M1 date?
http://www.pttbn.com/AskMeColumnE.png

I opted for Your option to use the actual start/end dates for each row.
Many thanks for help.

In my sheet: C24:E24 and C25:E25, both in years, months and days.
I tried treat dates as a whole and find a solution around . First view Attachment.

Attachment

Thanks, JBeaucaire, Your words "subtracting DATES is simple when you treat dates as a whole" not disputed, but I need to break out years and months and days because working experience in the...

Sorry for Attachment!

It's here.

Help, please,
http://www.pttbn.com/images/we.png
My biggest problem is how to add and subtract days, months and years in columns E23:E27, D23:D27 and C23:C27.
View Attachment.
Thanks.

What to say? Man is a genius.

Thanks.

Edited question, View image, please.

Help please,
View Image,

http://www.pttbn.com/media/downloads/1.png

Thanks

Help, please,
View attachement.

Thanks

Exactly what I need. Great answer. You are the best.

Thanks!

I am from Bosnia And Herzegovina. Our currency is Convertible Marka (KM), and Banknote are: 200, 100, 50, 20, 10 KM, and the Coins in denomination of 5, 2, 1, 0.50, 0.20, 0.10 and 0.05 KM. I need...

Yes, it's so.

I'll try to explain,

Desktop\Night_ReviewArticle.xls is the working file, and C:\ReviewArticle\Archive\Night\DD.MM.YYYY_Night_ReviewArticle.xls is the archive file.

Today is...

This kept the file in two locations under the names I needed and tis is OK.
Besides this I need that a saved file with one name forever preserved under this name, regardless of the opening under a...

That's it!


Another request
When I close the file first time, he saved as, for example, 22.05.2010_night_reviewarticle.xls. I need to each following closure of that file one copy kept on the...

I need to save file on c:\abcd\efgh\ijkl folder.

Part of script that save file on Desktop:

Dim DTAddress As String
DTAddress = CreateObject("WScript.Shell").SpecialFolders("Desktop") &...

RESOLVED!

For JBeaucaire,
I don't know did you see all six conditions in EXcel 2003, and send them in another file.

Thanks for the advice.

Which 6, show me, PLEASE, and I will add them in Excel 2007.

Sorry, my fault. Here's a file in xlsx format. Please help.

Thanks

Try this,

Thanks

I need formula to repeat event every 4 day in Excel calendar, starting 03.04.2010.

Thanks

DOWNLOAD ATTACHMENT

S= session number
P= the presence of session
1,2,3,4,5... = session order number
1 (red) or empty= attend or not attend the session

I NEED:

Conditional Formatting...

All work fine, but...

Print layout after added rows is not same. How erase number of added rows below double red line.
If I insert, for example, 5 rows, same number of rows (5) I need to erase...

NO, it surely me.Try this one.

Why the values in Figure 2 were inserted?

Figure 1 is part of larger project that has predefined tables with predefined numbers of rows. Sometimes, really sometimes, table need additional rows and...

Error. See below.

NO other spreadsheets. FIGURE 1 reprsent table before inserting rows and FIGURE 2 after that.

Specific task. See Attachment.

Thanks!

I was attempt "RATE ANSWER", but I get message "You must spread some Reputation around before giving it to JBeaucaire again.". How solve that?

What to say? You are simply THE BEST.

THANKS! THANKS! THANKS! THANKS! THANKS!

What to say? You are simply THE BEST.

THANKS! THANKS! THANKS! THANKS! THANKS!

When I type (Sheet "Pretraga") e.g. "Popovi" in cell A2, in cell F2 must be 76300 BIJELJINA, 76218 RAZLJEVO, 75436 SKELANI (see Sheet "Mesta", red color).

I get only first result of...

That is IT.

Thank You very much, JBeaucaire.

http://www.pttbn.com/66.jpg

http://www.pttbn.com/77.jpg

http://www.pttbn.com/88.jpg

No, NOT work.

After

Highlight cell C57:L57
Press Ctrl-1
Select Border
Add the dark line at the TOP.

Print Preview, Next

Thanks, JBeaucaire, this macro is useful for me, but what about "Black border between C and L columns in transition between first and second page"?

FOR JBeaucaire, primarily

I now that is too much from me, but I'm enforced to complet this app.

1. Black border between C and L columns in transition between first and second page

2. VBA...

Hello,
Business trip, sorry

See picture

http://www.pttbn.com/55.jpg

I can't set red line to black border.
Row 48 MUST BE intact.

Thanks,JBeaucaire. That is it... BUT!!

SEE PICTURES ABOVE, AGAIN

Can You set conditional formatting WITHOUT red line, AND black line extend to columns K and L.

Thanks in advance!!

Here are what's shall

http://www.pttbn.com/11.jpg

http://www.pttbn.com/22.jpg

http://www.pttbn.com/33.jpg

http://www.pttbn.com/44.jpg