I've been trying to figure out how to apply Conditional Formatting to a range of cells on a spreadsheet, but so far I haven't succeeded. I'm generating a spreadsheet which needs to have conditional formatting to show a cell's background as red when the value is below 6, yellow when between 6 and 12, green when over 12 etc. Would anyone be kind enough to post even a small snippet of code to correctly create a Conditional Formatting rule and then apply it please?
I know there was some talk on the forum of a sample being included back in September 2013, but I haven't managed to find that either
