On Saturday, November 10, 2012 7:16:01 PM UTC-5, wrote:
I don't know what happened but conditional formatting suddenly greyed out from my workbook and all conditional formatting I applied gone! I checked workbook is not protected or shared. In fact, the strange thing is I open a blank new workbook and when I copy anything from the other worksheet over, it disables conditional formatting on new book also. Does anyone know what in the world is going on?



Can't wait to discover a new Microsoft Bug :)

apparently I closed all excel processes. Reopened the workbook and it works now :)

Strange.