| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Separate Conditions for Cond. formatting
1st need: Shading every other row. I have this figured out.
2nd Need: (this is where problems begin) I need to CF so that the date in the cell becomes red if it is 320 days old. I am using "cell value is, less than, =TODAY()-320" It works when it's alone, but when I use it WITH the 1st (above) CF, it only works for every other row. How can I combine these two to show BOTH every other row shaded and turn red if it is older than 320 days old. Thanks for the help. (I did search, I just couldn't find this particular issue) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Two Separate Conditions for Cond. formatting
All that's necessary is to simply enter your date formula as the *first*
condition, and the row shading as your *second* condition. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message oups.com... 1st need: Shading every other row. I have this figured out. 2nd Need: (this is where problems begin) I need to CF so that the date in the cell becomes red if it is 320 days old. I am using "cell value is, less than, =TODAY()-320" It works when it's alone, but when I use it WITH the 1st (above) CF, it only works for every other row. How can I combine these two to show BOTH every other row shaded and turn red if it is older than 320 days old. Thanks for the help. (I did search, I just couldn't find this particular issue) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Two Separate Conditions for Cond. formatting
On Jun 26, 6:02 pm, "Ragdyer" wrote:
All that's necessary is to simply enter your date formula as the *first* condition, and the row shading as your *second* condition. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! wrote in message oups.com... 1st need: Shading every other row. I have this figured out. 2nd Need: (this is where problems begin) I need to CF so that the date in the cell becomes red if it is 320 days old. I am using "cell value is, less than, =TODAY()-320" It works when it's alone, but when I use it WITH the 1st (above) CF, it only works for every other row. How can I combine these two to show BOTH every other row shaded and turn red if it is older than 320 days old. Thanks for the help. (I did search, I just couldn't find this particular issue)- Hide quoted text - - Show quoted text - Unless I am doing something wrong it isn't working. The shaded rows are picking up the conditioning on the dates I think. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Two Separate Conditions for Cond. formatting
That was the request!
The date format should supercede the row format. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "VegasSageV" wrote in message oups.com... On Jun 26, 6:02 pm, "Ragdyer" wrote: All that's necessary is to simply enter your date formula as the *first* condition, and the row shading as your *second* condition. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! wrote in message oups.com... 1st need: Shading every other row. I have this figured out. 2nd Need: (this is where problems begin) I need to CF so that the date in the cell becomes red if it is 320 days old. I am using "cell value is, less than, =TODAY()-320" It works when it's alone, but when I use it WITH the 1st (above) CF, it only works for every other row. How can I combine these two to show BOTH every other row shaded and turn red if it is older than 320 days old. Thanks for the help. (I did search, I just couldn't find this particular issue)- Hide quoted text - - Show quoted text - Unless I am doing something wrong it isn't working. The shaded rows are picking up the conditioning on the dates I think. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Two Separate Conditions for Cond. formatting
On Jun 26, 7:12 pm, "Ragdyer" wrote:
That was the request! The date format should supercede the row format. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! ---------------------------------------------------------------------------"VegasSageV" wrote in message oups.com... On Jun 26, 6:02 pm, "Ragdyer" wrote: All that's necessary is to simply enter your date formula as the *first* condition, and the row shading as your *second* condition. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! wrote in message groups.com... 1st need: Shading every other row. I have this figured out. 2nd Need: (this is where problems begin) I need to CF so that the date in the cell becomes red if it is 320 days old. I am using "cell value is, less than, =TODAY()-320" It works when it's alone, but when I use it WITH the 1st (above) CF, it only works for every other row. How can I combine these two to show BOTH every other row shaded and turn red if it is older than 320 days old. Thanks for the help. (I did search, I just couldn't find this particular issue)- Hide quoted text - - Show quoted text - Unless I am doing something wrong it isn't working. The shaded rows are picking up the conditioning on the dates I think.- Hide quoted text - - Show quoted text - I'm sorry, I did not explain it properly. I am using the following: CF1--Cell Value is, less than, =TODAY()-320" turns date Red. CF2--Formula is, =MOD(ROW(),2)=1 turns every other row shaded. What happens with the above scenario is that for every cell that should be shaded blue (CF2), if it also has the red date (CF1), it does not shade as it should for CF2. Instead it is the default white, no border. Hopefully this explains it better. I am new to the group and somewhat new to excel. Thanks. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Two Separate Conditions for Cond. formatting
Let's start at the top.
Answer these questions.. Exactly what rows and columns are you including in the CF? Is it something like A1 to Z100 ... or what? Exactly what rows and/or columns will contain a date? Is it something like A1 to A100 ... or A1 to Z1 ... or *every cell ... or what? Are the dates keyed in, or are they the returns from formulas, or are they imported from another application? With this info I'll try to duplicate your scenario as closely as possible. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "VegasSageV" wrote in message oups.com... On Jun 26, 7:12 pm, "Ragdyer" wrote: That was the request! The date format should supercede the row format. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! ---------------------------------------------------------------------------"VegasSageV" wrote in message oups.com... On Jun 26, 6:02 pm, "Ragdyer" wrote: All that's necessary is to simply enter your date formula as the *first* condition, and the row shading as your *second* condition. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! wrote in message groups.com... 1st need: Shading every other row. I have this figured out. 2nd Need: (this is where problems begin) I need to CF so that the date in the cell becomes red if it is 320 days old. I am using "cell value is, less than, =TODAY()-320" It works when it's alone, but when I use it WITH the 1st (above) CF, it only works for every other row. How can I combine these two to show BOTH every other row shaded and turn red if it is older than 320 days old. Thanks for the help. (I did search, I just couldn't find this particular issue)- Hide quoted text - - Show quoted text - Unless I am doing something wrong it isn't working. The shaded rows are picking up the conditioning on the dates I think.- Hide quoted text - - Show quoted text - I'm sorry, I did not explain it properly. I am using the following: CF1--Cell Value is, less than, =TODAY()-320" turns date Red. CF2--Formula is, =MOD(ROW(),2)=1 turns every other row shaded. What happens with the above scenario is that for every cell that should be shaded blue (CF2), if it also has the red date (CF1), it does not shade as it should for CF2. Instead it is the default white, no border. Hopefully this explains it better. I am new to the group and somewhat new to excel. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cond formatting | Excel Discussion (Misc queries) | |||
| Cond Format - 7 conditions | Excel Discussion (Misc queries) | |||
| cond formatting ? | Excel Worksheet Functions | |||
| Cond formatting | Excel Discussion (Misc queries) | |||
| Cond Formatting & Validation | Excel Discussion (Misc queries) | |||
Hybrid Mode
