View Single Post
 
Old 11-14-2012, 05:24 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,747
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

One way would be using Conditional formatting
If you plan to always enter your reference date in D59 try the following :
Select the range containing tour dates to check (say D150) - go to Conditional Formatting - Use a formula
As formula enter
Code:
=COUNTIF($D1:$D50, D59)
and choose the format you want when the condition is true The formatting of the duplicate will then change in your range

If the dates in range D150 are not true dates, let us know so w can help further

There are also other possibilities
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote