need some help with conditional formatting. Take a look at the sheet below. I would like to apply conditional formatting to D20 based on the vales of C20. For example, I want it to be on a color scale with the midpoint being the value in C20 and the min value be 2% and the max value be 2%. So if the value in D20 is higher than C20 it is a red shad and lower than C20 a green shade. I want it to be a percentage so that I can copy and paste it to other months and cells.