Range("a1").interior.pattern = xlGrid gives the cell a grid pattern
and Range("a1").interior.pattern = xlCrissCross gives the cell a criss cross pattern
But how do I color a cell two gradient colors diagonally? (Like one can with drawing objects).
Also, how can I find other xlpattern listings?