Most RecentMost ViewedMost LikesInsert Pictures in Cells with the IMAGE Function Using the new IMAGE function, pictures can now live in the cell and be the cell value instead of floating on top of it! Announcing LAMBDAs to Production and Advanced Formula Environment, A Microsoft Garage Project Today we are promoting LAMBDAs to production and releasing a new tool, Advanced Formula Environment, A Microsoft Garage Project. Finding the data and to color code it Hi, I have a excel where i need to find data from Crtl+F and I have to color code that cell in green. i have to manually search that data and do the process. How i can do in one go? Please reply with any of your thoughts. It might be helpful for me. Which formula to use Hello, I am looking for a formula but I don't know which one to use. What I would like to do is that when in collum material is entered 1804 that it multiplies the collum quantity with 34,3. And the result is shown in collum plan(hours). But if in collum material is entered 1800 that then it is multiplied with 17,2 and collum quantity and result again is shown in collum plan(hours). File is in the attatchment. Can anyone tell me which formula would work for this? Below my file: Shift Ordernumber line Material Quantity Plan(hours) Reality(hours) Operator Comments 1 1992620 10 1804 100 RH 1 1992621 20 1800 0 2 156461 20 1800 100 time per second 1804 34.3 1800 17.2 Solved
