I’m a competent Excel user, but I know only a very little about VBA programming. The difficulty I'm having concerns the conditional formatting function of Excel. A simplified explanation of the problem is I have a spreadsheet where the format of cell A2 depends on the value in the cell A3. I have 10 possible options for the formatting of background/borders. Thus I need more that the 3 (or 4 if you include the base format) conditional format options that excel offers. Is there a piece of VBA code I can paste into the 'View Code' view in my spreadsheet to help sort this? I've searched this web site for an answer to this and although there seem to be many solutions based on the contents of the cell to be conditionally formatted, there are few based on the contents of another cell from that to be formatted. I need multiple options based on the "formula is" rather than the "cell value is" functionality of the conditional formatting tool.
I've attached an example of the problem I have, and showing the 10 possible options I'm after.
Any help would be most greatly appreciated.