I have a worksheet that is conditonally formatted to change the interior
color of every other row to make viewing the data easier. I have one
particular column that contains dates. I want to add a second condition that
if the date in the column is less than today's date then change interior
color to red. I want this second condition to take priority over the first
condition, how can I do that in Excel 2003?
--
Cheers,
Ryan