• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by vvgiri

  1. V

    Index and Match

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

    Index and Match

    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...
  3. V

    Index and Match

    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...
  4. V

    Index and Match

    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...
  5. V

    Compare two columns on conditions

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

    Compare two columns on conditions

    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"
  7. V

    Compare two columns on conditions

    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.
  8. V

    Compare two columns on conditions

    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...
  9. V

    Gradient fill [SOLVED]

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

    Gradient fill [SOLVED]

    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...
  11. V

    Gradient fill [SOLVED]

    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...
  12. V

    Downloadable cell styles. themes

    Thank you bobhc, will try that now Regards, Giri
  13. V

    Downloadable cell styles. themes

    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
  14. V

    Downloadable cell styles. themes

    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...
  15. V

    copying conditional formatting

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