# Search results

1. ### Moon Phases in Excel

Is it possible to Calculate Moon Phases in Excel dynamically every Month
2. ### Calculation of Moon Phases in Excel

Is it possible to calculated the moon phases in excel dynamically every month.
3. ### EVENT LOOKUP WITH TIME CALCULATIONS

THANK YOU FOR THE HELP. WORKING GOOD.

Thank you.
5. ### EVENT LOOKUP WITH TIME CALCULATIONS

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.
6. ### EVENT LOOKUP WITH TIME CALCULATIONS

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,
7. ### EVENT LOOKUP WITH TIME CALCULATIONS

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
8. ### Highlighting cells in a column from the differences of other cells

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...
9. ### Highlighting cells in a column from the differences of other cells

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
10. ### Highlighting cells in a column from the differences of other cells

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

12. ### Highlighting cells in a column from the differences of other cells

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.
13. ### POSITION OF CELL VALUE IN A RANGE

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
14. ### POSITION OF CELL VALUE IN A RANGE

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
15. ### Excel 2003 Password Protection

Is there any other way to protect the excel file.

17. ### Excel 2003 Password Protection

May you please explain.
18. ### Excel 2003 Password Protection

But how and what will be the macro code to do this practically.
19. ### Excel 2003 Password Protection

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...
20. ### Cell highlighted in a given range

Exactly. Thank you very much. It has solved my problem. With regards pucha
21. ### Cell highlighted in a given range

yes, the number very close to the the value j6.
22. ### Cell highlighted in a given range

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.
23. ### Cell highlighted in a given range

Not showing anything.
24. ### Cell highlighted in a given range

But it showing anything.
25. ### Cell highlighted in a given range

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