I have a column F that has dates in it that I want to turn pink if they are 30 from the date entered. The format of the date entered is 11-Oct-06. I totally forget how to write this inside Visual Basic editor. Can I just use Conditional Formatting? How? Thanks in advance...