Custom Conditional Formatting Colors 1

[jaaret]

Is there a way to apply custom conditional formatting background and font colors, or am I limited to the palette provided in the Condtional Formatting Dialogue Box?

 

[Remou]

You can build Conditional Formats programmatically and these formats can use custom colours:

Private Sub Form_Open(Cancel As Integer)
Dim FCS As FormatConditions, FC As FormatCondition
   
    'Date
    Set FCS = Me!Updated.FormatConditions
    FCS.Delete ' Delete all format conditions
    Set FC = FCS.add(acFieldValue, acEqual, "#29/06/2007 05:46:50#")
    FC.BackColor = 9033867
    Set FC = Nothing
    Set FCS = Nothing

End Sub