I'm coming in the middle of the thread, so, what version of Excel are you
using? Excel 2003 and earlier had three levels of conditional  formatting,
Excel 2007 has far more.

To find out how to do conditional formatting in VBA, use Record Macro and
play with the conditional formatting. This will give you some basic VBA code
to demonstrate how to code Conditional formatting.