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: