Conditional formatting is applied in the order that they are created.

If Condition 1 = True then
apply Format 1
elseif Conditon2 = true then
apply Format 2
elseif Conditon3 = true then
apply Format 3
end if

So if the first conditon is met then the second condition is never
evaluated. As a guess you just have your conditions in the wrong order...
--
HTH...

Jim Thomlinson


"RyanH" wrote:

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