Watch for more Excel tips as part of our fee schedule analysis example in Excel Video 233. We’ll use the division rules from Excel Video 231, format the results as a percentage, and then once we have our formulas ready, we’ll use the double-click trick to fill the formulas down to each code.
I’m changing the cells’ formatting to green and red using a technique called Conditional Formatting. I started covering Conditional Formatting in Excel Video 44 and there’s a Conditional Formatting playlist on the videos page. Conditional Formatting is helpful when you’re looking at 10 codes. Imagine how helpful it would be with 1,000 codes.
Stay tuned. We’ll keep analyzing the fee schedule in the next Excel Video.
