How could I do something similar in using a colour to highlight differences in stock levels on two sheets. Sheet one like the above has an item name and quantity including a product code. The second sheet has the same columns but could have different stock quantity as its what is available in the warehouse. Basically I'd like a green to show in the quantity cells if the stock level is the same on both sheets and red if they are different.
Thanks for your question! To highlight differences in stock levels between two sheets in Excel, you can use conditional formatting. Here's how: 1. Select the Quantity Range on Sheet1 (e.g. C2:C20). 2. Go to Home > Conditional Formatting > New Rule. 3. Choose "Use a formula to determine which cells to format" and enter =C2=Sheet2!C2 for matching quantities, formatting with a green fill color. 4. Add another rule for differences with the formula =C2Sheet2!C2, formatting with a red fill color. This way, matching quantities will be green and differing quantities will be red. Check out the video I created on this topic: th-cam.com/video/VCmF_saotw4/w-d-xo.htmlsi=U4-BMpISpcitzkfP
How could I do something similar in using a colour to highlight differences in stock levels on two sheets. Sheet one like the above has an item name and quantity including a product code. The second sheet has the same columns but could have different stock quantity as its what is available in the warehouse. Basically I'd like a green to show in the quantity cells if the stock level is the same on both sheets and red if they are different.
Thanks for your question! To highlight differences in stock levels between two sheets in Excel, you can use conditional formatting. Here's how:
1. Select the Quantity Range on Sheet1 (e.g. C2:C20).
2. Go to Home > Conditional Formatting > New Rule.
3. Choose "Use a formula to determine which cells to format" and enter =C2=Sheet2!C2 for matching quantities, formatting with a green fill color.
4. Add another rule for differences with the formula =C2Sheet2!C2, formatting with a red fill color.
This way, matching quantities will be green and differing quantities will be red.
Check out the video I created on this topic: th-cam.com/video/VCmF_saotw4/w-d-xo.htmlsi=U4-BMpISpcitzkfP