Hi folks, I have been using Conditional Formatting for a while now. I am at a point where I need to do a lot more formatting than is provided for by the 3 conditions that are in Excel. I know this can be done with Visual Basic. One of my weaknesses as a trader is that I don't have any programming knowledge. Here's the scenario: I have a cell that is computed (D57) If the cell equals the Open (D60), then it should be colored GREEN (or whatever) If the cell equals the High (D61), then it should be colored RED (or whatever) If the cell equals the Low (D62), then it should be colored BLUE (or whatever) So on and so forth. I have about 12 different conditions and they are just simple values. Other than googling and running thru a bunch of threads and searches, does anyone have a simple sample code that I can use by varying the cell reference and the color?