Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Priority for Conditional Formatting in Excel 2003
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Priority for Conditional Formatting in Excel 2003
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Priority for Conditional Formatting in Excel 2003
On Sep 17, 11:25*am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote: 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- Hide quoted text - - 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL 2003 - Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 and 2007 priority setting | Excel Discussion (Misc queries) | |||
Conditional formatting in Excel 2003 | Excel Discussion (Misc queries) | |||
Priority order in conditional formatting | Excel Discussion (Misc queries) |