Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting with Due Dates, and different colors for da
I have tried numerous ways to make the below work but I cant figure it out.
All of the cells change to the color, instead of just one. I have a due date in Column E (manually entered) and need the following: From 7 days before the due date up to the actual due date, the cell needs to be Yellow. Anything from the due date forward, needs to be red. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting with Due Dates, and different colors fo
Brendan, yes you may choose the entire "E" Column, whatever the active cell
is, presumably "E1", is what you would type for the formula, Excel is smart enough to change the row for the rest of the cells as long as you don't use a $ in front of your row number. -- Charles Chickering "A good example is twice the value of good advice." "Brendan" wrote: I noticed you used A1 in the formula. Since I am using the entire E column, can I simply highligh the entire column or so I have to do something else to force each new entry on a subsequent row in the E column? "Charles Chickering" wrote: Brendan, you'll need to specify 2 conditional format conditions he 1 use this formula: =A1<=TODAY() and choose the pattern red 2 use this formula: =(A1-TODAY())<7 and choose the pattern yellow Post back if I misinterpreted something wrong -- Charles Chickering "A good example is twice the value of good advice." "Brendan" wrote: I have tried numerous ways to make the below work but I cant figure it out. All of the cells change to the color, instead of just one. I have a due date in Column E (manually entered) and need the following: From 7 days before the due date up to the actual due date, the cell needs to be Yellow. Anything from the due date forward, needs to be red. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting with Due Dates, and different colors fo
I noticed you used A1 in the formula. Since I am using the entire E column,
can I simply highligh the entire column or so I have to do something else to force each new entry on a subsequent row in the E column? "Charles Chickering" wrote: Brendan, you'll need to specify 2 conditional format conditions he 1 use this formula: =A1<=TODAY() and choose the pattern red 2 use this formula: =(A1-TODAY())<7 and choose the pattern yellow Post back if I misinterpreted something wrong -- Charles Chickering "A good example is twice the value of good advice." "Brendan" wrote: I have tried numerous ways to make the below work but I cant figure it out. All of the cells change to the color, instead of just one. I have a due date in Column E (manually entered) and need the following: From 7 days before the due date up to the actual due date, the cell needs to be Yellow. Anything from the due date forward, needs to be red. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting with Due Dates, and different colors for da
Brendan, you'll need to specify 2 conditional format conditions he
1 use this formula: =A1<=TODAY() and choose the pattern red 2 use this formula: =(A1-TODAY())<7 and choose the pattern yellow Post back if I misinterpreted something wrong -- Charles Chickering "A good example is twice the value of good advice." "Brendan" wrote: I have tried numerous ways to make the below work but I cant figure it out. All of the cells change to the color, instead of just one. I have a due date in Column E (manually entered) and need the following: From 7 days before the due date up to the actual due date, the cell needs to be Yellow. Anything from the due date forward, needs to be red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting question with colors | Excel Discussion (Misc queries) | |||
Conditional Formatting - Not all colors work? | New Users to Excel | |||
Conditional Formatting - more than 4 cell colors | Excel Worksheet Functions | |||
Conditional Formatting with Colours / Colors | Excel Worksheet Functions | |||
Conditional Formatting in 6 colors | Excel Discussion (Misc queries) |