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