I am preparing financial reports and many other reports to my clients. I noted that although in Microsoft word we can insert a watermark to the pages, in Microsoft excel there is no option to insert a watermark. Can anyone help me with this?

I want to change the background color of the cell according to the value.

I have an itemized list and value which are issued to main stores to branches.

There are different amounts of item value. I want to change the color of each cell according to the value based on the following conditions.

Less than 25,000.00                                         Yellow

Between 25,000.00 and 50,000 Red

Hi all,

For more than 3 years, I have been running AutoMate 6 and last week I had started getting an error message in the process of sending email.

 I can send email with Excel files but because of this error I cannot do it.

The error message:

Error: DISCARD SPAM (Code: 0)

Need your help to solve it. Please.

Thanks.

I have heard that charts are able to create in Microsoft excel easily. I tried to make a chart.

However, it was not successful. Can anyone explain me to make a chart with an example?

Thanks.

I believe that you can help me with this problem if you have an experience in excel. I have an excel sheet including purchase details from customers.

Please see the image below. This is only a sample.

I want to extract balance figure out at every month end (Only the balance at month end). Can help?

Hi expert,

I am keeping record of a company in an excel sheet which includes data about suppliers and their value of item purchased from them. There are more than 500 suppliers and each supplier has separate excel sheet. Following is a sheet of one supplier.

All sheets are in the same format. I want to create a summary sheet which includes all names of suppliers in to sheet at the front. Can you tell me a way to get all names to a one sheet easily without copy paste?

One of my clients is providing loans to customers which repayments should be done daily. If a customer unable to pay more than two days he will have to pay a penalty charge on the next day.

But the company does not open on Sundays. Therefore I want to have a date period in an excel sheet which represent six month period except Sundays. It should be like this.

If I entered the date (date when the loan is provided) in cell B2 Following days should be appeared to in below cells except Sundays. Please see the image.

I have a Microsoft excel sheet including details of the loan providing to staff members of a company. These loans are recovered with an interest. These interest rates are variable with the loan value as follows.

Loan value                                                          Interest rate

Hi expert,

Can you help me to solve this Excel problem?

In my excel sheet there is a table which includes thousands of data. (See the image).

When I am going to print this table headings are displayed only on the first page.

But I want to heading are available in every page print.

How can I get the heading to each page I print?

Thanks.

I have an excel file which includes more than hundred spread sheets. All these sheets include customer details and all are in a same format.

Now I want to add some formulas to all these sheets. But it takes a long time to copy and paste these formulas to all pages.

So, how can I apply a same formula to all sheets at once. Could you help me?