| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I have a column (J) with due dates expanding to 2015. I would like the due
date to change color when: 1. Due date is within 15 day of today's date (Yellow). 2. Due date is pass today's date (Red) 3. Due date is out pass 365 days (No color) Can this be done? -- pls |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
hi
assuming that you due date is in A1, in A1..... 1.cell value is......less than.......=today()+15 2.cell value is..... less than......=today() 3. to me no color means no CF. Regards FSt1 "Pat" wrote: I have a column (J) with due dates expanding to 2015. I would like the due date to change color when: 1. Due date is within 15 day of today's date (Yellow). 2. Due date is pass today's date (Red) 3. Due date is out pass 365 days (No color) Can this be done? -- pls |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
I tried your suggestion and it didn't work. Is it because I have a formula
in J Column calculating the due date. -- pls "FSt1" wrote: hi assuming that you due date is in A1, in A1..... 1.cell value is......less than.......=today()+15 2.cell value is..... less than......=today() 3. to me no color means no CF. Regards FSt1 "Pat" wrote: I have a column (J) with due dates expanding to 2015. I would like the due date to change color when: 1. Due date is within 15 day of today's date (Yellow). 2. Due date is pass today's date (Red) 3. Due date is out pass 365 days (No color) Can this be done? -- pls |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
hi
I tested. mine works with formulas. using 2003. but i did notice something. redo the CF like this and see if that helps.... 1.cell value is......less than.......=today().............red 2.cell value is..... less than.......=today()+15.......yellow regards FSt1 "Pat" wrote: I tried your suggestion and it didn't work. Is it because I have a formula in J Column calculating the due date. -- pls "FSt1" wrote: hi assuming that you due date is in A1, in A1..... 1.cell value is......less than.......=today()+15 2.cell value is..... less than......=today() 3. to me no color means no CF. Regards FSt1 "Pat" wrote: I have a column (J) with due dates expanding to 2015. I would like the due date to change color when: 1. Due date is within 15 day of today's date (Yellow). 2. Due date is pass today's date (Red) 3. Due date is out pass 365 days (No color) Can this be done? -- pls |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
hi again
i am assuming that you did know to adjust the range to column J. in my first post, i assumed your dates were in column A and told you to put the CF in A. if you did put the CF in A, move it to J. just making sure. regards FSt1 "FSt1" wrote: hi I tested. mine works with formulas. using 2003. but i did notice something. redo the CF like this and see if that helps.... 1.cell value is......less than.......=today().............red 2.cell value is..... less than.......=today()+15.......yellow regards FSt1 "Pat" wrote: I tried your suggestion and it didn't work. Is it because I have a formula in J Column calculating the due date. -- pls "FSt1" wrote: hi assuming that you due date is in A1, in A1..... 1.cell value is......less than.......=today()+15 2.cell value is..... less than......=today() 3. to me no color means no CF. Regards FSt1 "Pat" wrote: I have a column (J) with due dates expanding to 2015. I would like the due date to change color when: 1. Due date is within 15 day of today's date (Yellow). 2. Due date is pass today's date (Red) 3. Due date is out pass 365 days (No color) Can this be done? -- pls |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
Dates that are over 365 days are turning yellow. Thank you for your help.
-- pls "FSt1" wrote: hi I tested. mine works with formulas. using 2003. but i did notice something. redo the CF like this and see if that helps.... 1.cell value is......less than.......=today().............red 2.cell value is..... less than.......=today()+15.......yellow regards FSt1 "Pat" wrote: I tried your suggestion and it didn't work. Is it because I have a formula in J Column calculating the due date. -- pls "FSt1" wrote: hi assuming that you due date is in A1, in A1..... 1.cell value is......less than.......=today()+15 2.cell value is..... less than......=today() 3. to me no color means no CF. Regards FSt1 "Pat" wrote: I have a column (J) with due dates expanding to 2015. I would like the due date to change color when: 1. Due date is within 15 day of today's date (Yellow). 2. Due date is pass today's date (Red) 3. Due date is out pass 365 days (No color) Can this be done? -- pls |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
