Hi all,


I need some help creating a rule to highlight cells that correspond to some criterias.


Column A = House numbers ( It has several numbers and some are duplicated )
Column B = Date of Arrival
Column C = Date of Departure

What i wanted to do is to create a rule that if the same House has:

Departure ( Date on Column C ) is equal to the Arrival ( Date on Column B ) are equal it highlights the House Number ( Column A ) cell corresponding to the Arrival Date.


Example:

Column A / Column B / Column C
House / Arrival date / Departure date

1 - 20-3-2010 - 24-3-2010
1 - 24-3-2010 - 29-3-2010
4 - 20-4-2010 - 25-4-2010
12 - 12-3-2010 - 16-3-2010


Meaning that it would highlight those above in red