Set Priority for Conditional Formatting in Excel 2003

[RyanH]

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?

 

[Jim Thomlinson]

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...

 

[Excel.Instructor]

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





- Show quoted text -

Ryan-
Jim is correct. The precedence is set on which order they occur. To
do what you need, highlight just the cells in the date column and
bring up Conditional formatting. The every other row formatting
should be listed as condition 1. Add a second condition and make it
equal to the first condition. Then, go back to the first condition
and modify it to do the red formatting.

It's just a matter of reordering the conditions.