i want to change the colour of a row of data based on the dates.
im making a mailbook, in column H i have received date, I reply date
and in J actual date replied.
what im trying to do is highlight mail not replied to within the limits
of the reply date, but not if there is no date entered. im also trying
to highlight if the actual reply date is before the received date.
& im stuck somewhere in middle!
can anyone offer me some advice?