(Solved) – VBA use gradient colors when a condition fails


How can I set a cell color to show a gradient of colors when a condition fails. I am new to Excel VBA programming and I came across a similar question on here that asked the questioner to use macro recorder to get the code. I have never used a macro recorder and would appreciate if someone could point me in the right direction. Anyhow, I would like the following color gradient for a cell should a condition pass/fail.

This is the color gradient I am looking for:

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *