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.


1 Answer 1


You'll need to create a column of colors (in your file A8: A17) and then conditional format it together with cell D20, as in this picture:


The cell A8 will have the formula:

= sequence (10,1,0, C20 / 5)

See your modified file

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.