|How do I create a formula to calculate and percentages and then format?|
Im trying to create a fairly complex percentage formula to track inventory. The goal is to mark my current spare count if it falls below 3% of the total units that I have deployed.
If column E is the number I have in deployed and column F is the number I have spared, I need F to format if it falls below 3 % of E.
Any help would be greatly appreciated.