I am trying apply a 3 color scale to cell C3 based on the results of the formula in cell D3 which sums 6 cells and then divides by another (all determined by formulas dependent on the selection of drop down lists starting on row 9 col C). Do I need to build a macro to do this or can I use the Conditional Formatting Rule. I have tired a few ways but nothing has worked for me unless I am in cell D3 and even then the colors do not display properly. My criteria is Red if below 75%, Yellow between 89 and 76%, and Green if Above 90%.

Any Help will be greatly appreciated.