Hi, I am using Excel 2003 and would like a conditional format to work with a
named range, is that possible? I have a named Range called City in column b.
When the city changes I would like for the entire row to change to a specific
color I designate. I have used this formula =$b16<$b15 and this works until
I filter the data. Please if anyone has done this or something close I would
like to see your formula.

Thanks,
John