I am trying to make a graph that changes colors when it reaches its target. I.E. Below Target = Green Above Target = Red.
I have the data set up in three columns, <=Target, >Target, and Target.
The formulas I have are =IF(U121<=CF121,U121,NA()) and =IF(U121>CF121,U121,NA())
My problem lies...