I am trying to take a formula: =(CI74*4/5)+(CI75*3/4)+(CI76*3/3)+(CI77*1/3)
And have it populate 4 other cells with color and with the #1 in it.
This is for revenue projection. The other 4 cells are different months. the 4 months represent projected revenue during that time frame.