Recent content by pucha

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.