Hi,
What I am trying to figure out is if I state a range being say from $A$1:$A$100, each containing a date.
How do you then do an IF function in VBA so that if a date entered is which is either less, equal or greater than a stated date, the cell colour and text formatting is changed accordingly in real time.
The conditional formatting tool on this occasion is not applicable due to the data being copied and pasted from other sources.
Brian.
Bookmarks