Conditional Formatting

[Jw888888]

Hello!I am trying to use excel to highlight a revised ship date. I have a column of estimated ship dates and revised ship dates. The estimated ship dates can range from any date in the week (ie 5/16, 5/17 etc) The revised ship date is changed manually. How can I format excel so every time a revised ship date that is enter that is later than the estimated ship date it highlights the revised ship date red. I used conditional formatting to highlight the cells when there is 1 finite date. However in my case I have a whole range of dates I need to compare to. Any help is appreciated J

Continue reading...