Search results

Yes brother, it is working . I am struggling since very long time to find solution to my problem . Thanks once again for the help.

Thank you very much, it is working now. One more request if not a problem to you. The current status and schedule come from different sources they do not use same terminology. So the if formula IF P3=Q3 , not working in some cases. some times in the schedule STOP-MECH, STOP-ELEC is used for...

Thank you very much for the help. My apologies for not being able to communicate my query. What i am looking for is to compare the equipments current status with the selected date from the schedule. when i enter the date in cell Q2 ( Date range is B2:M2),excel should fetch the entire column...

Hi all, i have a large database of Equipment annual Schedule. I want to compare equipment's current status with the desired status as per the schedule when i select the date. and also display " No action" if matching else Display" Changeover" if not matching. I tried using index and match...

Thank you for your time and advice. My issue is resolved now.

Thank you very much, just out of curiosity i am asking again whether we can if formula based on cell formatting? what i observed , running cells are in Green and Stopped cells are in RED. so how to write formula , like if D4 cell colour matches with E4, Then " OK" , else " CHANGE"

Thanks a lot for the help, Yes the terms are captured from POIS system, I can't change. If desired conditin is STOP and actual condition is STOPPED, then also should display OK.

Hi everyone, i am bit new to excel, i am struggling to find a formula for my task. I am in process industry, and we have equipment change over schedule. on every Friday we have to check all equipment for their desired condition from actual condition and take action accordingly. in short, if it...

Dear SirJB7, I have figured it out from the downloaded file, thanx again Regards, vvgiri

Dear SirJB7 Thank you for the help. infact what i wanted is to assign a different color to each team and apply gradient fill for that team. Like Red gradient fill to team 1 and Blue gradient to team 2 and so on. I have downloaded your file. Is there any way do this from the downloaded...

Dear all, i have prepared 8 teams for a tournament consisting of 15 members each team. I have placed them in a a order, best player at the top to weakest at no 15. I want to apply different color to each team and apply gradient fill to each team. From best player to weakest player. I tried...

Thank you bobhc, will try that now Regards, Giri

Thank you bobhc yes , i am using the format painter for copying, but when it comes to formatting large data at once , conditional formatting is the best i think. Thats why i am looking for the option to copy the format and use in conditional formatting, Thanks and regards, Giri

Hi friends, I am looking for any downloadable cell styles/ themes . I tried making my own , but not happy with the results. When i see some made by others , i wonder how they made it.Especially the colour combinations and effects. I checked downloads section, there are many templates and...

Yes, Bobhc this is somewhat relevant to my question, will try this now Thanks

I am really sorry, bobhc, my only intention is to make simple and straight forward, that's why re posted. thank you for the reply and advise, as i am new Forum member . i also learnt something new about manners. Really appreciated, sorry once gain, i hope you understand. Thanks Giri

Dear friends, can i copy and paste conditional formatting applied? Thanks and regards, Giri

Thank you Narayan, I could not select the by sections due to merged cells, selection became difficult. i even tried by increasing the colums/rows sizes. This way better than, single A3 page, but did not get what i exactly want. I tried with fit to 2 pages wide by 2 pages tall, still did not...

Dear all, i have shift calender excel file, which i want to enlarge it and print on four A3 size sheets and stick together. i tried in different ways but failed. Now i have printed in one A3 size paper ,i want this to past it on meeting room, as one A3 size print out still looks small in...

Dear Bobhc, thank you , it really worked , and i learnt something new today, thanx again, Giri

Hi, I am Giri, Indian National working in Qatar. I am new to Excel , started learning recently. Though i need some basic skills for my job, but find it very interesting , hence started to learn a bit more than basic skills

Dear friends, i have one more query. I have updated database with new phone numbers. How to delete old contacts column? since it is used in the formula, is there any way to do this other than hiding the column? I want to do the same for Family Name/Name Columns coz i have created full name...

Thank you Shrivallabha, i tried the formula you provided, it worked. Now learnt several ways to achieve this. Thank you all, and it is really use full for learners like me. Giri

Dear Mahavir , Wade and Kuashik thank you all for the support. My Problem has been solved now. Dear Wade, i am bit new to macros, though my problem is solved, i cound not figure out how this macro is created. Thank you all Regards, Giri

Dear friends i have a database of members with lots of details which is being maintained over 5 years now. couple of years ago, the phone numbers have changed from 7 digit to 8 digits. We have different series of phone numbers starting from 3, 4 5, 6 series. I need to add additional...