Search results

Is it possible to Calculate Moon Phases in Excel dynamically every Month

Is it possible to calculated the moon phases in excel dynamically every month.

THANK YOU FOR THE HELP. WORKING GOOD.

Thank you.

Thank you, I had not tried Gantt Chart before nor do I know how to do. If you think my Problem can be solved by it then pl help.

Thank you for your response. May be I had drawn the presentation like gantt-chart. but hope it will not be possible with that. As the program that I am looking is with "Minutes and seconds". Hope will you check my Excel file once again. Thanks Sir,

I am trying to find the event occurred as per given range of time. Suppose the time range is 09:14:28 to 09:53:22 want to find the event from the tables and also the time passed in the certain event (minutes and seconds) I have uploaded the excel file. Pl have time to look. Thankyou Pucha

Simply, this is a stock oriented showcase where open/high/low/close are given and a range of c5 to c53. You will find the values of open/high/low/close all are in the range c5 to c53. I just want to make a stock candlestick over this range. if high-open is less than open-low the the price is...

Yes, I used this formula in conditional formatting [=AND(ABS($G$4-$F$4)<=ABS($F$4-$H$4))] and this [=AND(ABS($G$4-$F$4)>=ABS($F$4-$H$4))] for getting the result I want but it shade the whole range c5:c53 into a single color. Yes K5 & K10 are the formulas that I want to Highlight. Thanks

VLETM, PLEASE FIND THE FILE. I HAVE UPLOADED A SAMPLE FILE

Any Solution please

Highlighting cells in a column from the differences of other cells. Sir i am not able to highlight few cells in column from a difference of other cells. I have uploaded a file for your understanding. Kindly check the file.

Thank you very much Mr. Hui. for solving the problem. and I also thanks to Mr. Bosco for doing it by another method. Both the methods are working. With Respect & Regards to both of you, Thanks Pucha

POSITION OF CELL VALUE IN A RANGE. I WANT TO KNOW WHETHER THE OPEN PRICE IS IN "OVERSOLD ZONE" OR IN "OVER BOUGHT ZONE". THANKS PUCHA

Is there any other way to protect the excel file.

Please explain.

May you please explain.

But how and what will be the macro code to do this practically.

Hello Sir, Is there any password coding method where an excel file opening in one computer will not open in another unless otherwise a password matching is done. Actually I had given an excel file to a friend's computer but I don't want that he should open that file in some another computer...

Exactly. Thank you very much. It has solved my problem. With regards pucha

yes, the number very close to the the value j6.

Thank you Chihiro. It is working . I was applying directly in formula. Thanks once again. Well is it possible to highlight the nearest number in the range instead of two cell. if possible please let me know. thanks With Regards.

Not showing anything.

But it showing anything.

It should be closet to the cell value. I have attached another file please check. There is an error uploading the file.