Hi all,

The following formula used in Conditional Formatting works fine for excel 2010 but not excel 2007. Any idea on how to modify it for it to work in 2007??

Formula: copy to clipboard 
=OR(D$5=Details!$D$10,D$5=Details!$D$11,D$5=Details!$D$12,D$5=Details!$D$13,D$5=Details!$D$14,D$5=Details!$D$15,D$5=Details!$D$16,D$5=Details!$D$17,D$5=Details!$D$18,D$5=Details!$D$19,D$5=Details!$D$20, D$5=Details!$D$21, D$5=Details!$D$22, D$5=Details!$D$23, D$5=Details!$D$24, D$5=Details!$D$25)


The formula essentially check whether each cell in column 5 is holiday or not based on a list in column D of sheet 'Details' (both sets of cells are date formatted).

Thanks!

Geoff.