All,
I have read JRD's post on COnditional formatting. It is very useful. However the VBA doesn't recalculate a cell's formatting until it is changed. Therefore if you require a change in any of the values that cause a change, the cells that had been formatted based on your previous values stay with their previous formatting. I need a way to check all cells at the opening of a sheet (at a minimum) and recheck all the cells for the proper value using the conditional formatting code. thanks for all your help on Yahoo JRD. BTW JRD suggested this code
Private Sub Workbook_Open()
Dim Cel As Range For Each Cel In Sheets("Sheet1").UsedRange Cel.Value = Cel.Value NextEnd Sub
or something similar. Although I think it is malformed due to using IM as the medium. Can anyone help?
thanks
-Justin