Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting date and blank cell
Using Excel 2003 -- I have a column which has a date entered into it. I need
this column to highlight the date if: 1. it is between today's date and 10 days from today in one color 2. it is past today's date in another color 3. do not show color in the cells that are blank I have highlighted the entire column, used the Conditional Formatting with the following: 1. Cell Value is between =TODAY() and =TODAY()+10 [yellow highlight] 2. Cell Value is less than =TODAY() [orange highlight] It is this second format that is causing blank cells (ones not yet used) to have an orange highlight. How do I correct this so that blank cells will have no highlight, yet keep the formatting for the other dates? Thanks! Audrey G. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting date and blank cell
Change condition to to
Cell Value is between 1 and TODAY() assuming you don't have any dates of 1/1/1900, this will work just fine. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Audrey G." wrote: Using Excel 2003 -- I have a column which has a date entered into it. I need this column to highlight the date if: 1. it is between today's date and 10 days from today in one color 2. it is past today's date in another color 3. do not show color in the cells that are blank I have highlighted the entire column, used the Conditional Formatting with the following: 1. Cell Value is between =TODAY() and =TODAY()+10 [yellow highlight] 2. Cell Value is less than =TODAY() [orange highlight] It is this second format that is causing blank cells (ones not yet used) to have an orange highlight. How do I correct this so that blank cells will have no highlight, yet keep the formatting for the other dates? Thanks! Audrey G. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting date and blank cell
For the second use Formula Is (not Cell Value is):
=AND(A2<"",A2<TODAY()) -- David Biddulph Audrey G. wrote: Using Excel 2003 -- I have a column which has a date entered into it. I need this column to highlight the date if: 1. it is between today's date and 10 days from today in one color 2. it is past today's date in another color 3. do not show color in the cells that are blank I have highlighted the entire column, used the Conditional Formatting with the following: 1. Cell Value is between =TODAY() and =TODAY()+10 [yellow highlight] 2. Cell Value is less than =TODAY() [orange highlight] It is this second format that is causing blank cells (ones not yet used) to have an orange highlight. How do I correct this so that blank cells will have no highlight, yet keep the formatting for the other dates? Thanks! Audrey G. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting date and blank cell
Thank you! This worked great!
-- Audrey G. "Luke M" wrote: Change condition to to Cell Value is between 1 and TODAY() assuming you don't have any dates of 1/1/1900, this will work just fine. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Audrey G." wrote: Using Excel 2003 -- I have a column which has a date entered into it. I need this column to highlight the date if: 1. it is between today's date and 10 days from today in one color 2. it is past today's date in another color 3. do not show color in the cells that are blank I have highlighted the entire column, used the Conditional Formatting with the following: 1. Cell Value is between =TODAY() and =TODAY()+10 [yellow highlight] 2. Cell Value is less than =TODAY() [orange highlight] It is this second format that is causing blank cells (ones not yet used) to have an orange highlight. How do I correct this so that blank cells will have no highlight, yet keep the formatting for the other dates? Thanks! Audrey G. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting date and blank cell
This worked as well. I don't know that I fully understand why it worked, but
I will get to that point later. Thanks so much! -- Audrey G. "David Biddulph" wrote: For the second use Formula Is (not Cell Value is): =AND(A2<"",A2<TODAY()) -- David Biddulph Audrey G. wrote: Using Excel 2003 -- I have a column which has a date entered into it. I need this column to highlight the date if: 1. it is between today's date and 10 days from today in one color 2. it is past today's date in another color 3. do not show color in the cells that are blank I have highlighted the entire column, used the Conditional Formatting with the following: 1. Cell Value is between =TODAY() and =TODAY()+10 [yellow highlight] 2. Cell Value is less than =TODAY() [orange highlight] It is this second format that is causing blank cells (ones not yet used) to have an orange highlight. How do I correct this so that blank cells will have no highlight, yet keep the formatting for the other dates? Thanks! Audrey G. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting if cell is Blank | Excel Worksheet Functions | |||
Conditional formatting - check for blank cell | Excel Discussion (Misc queries) | |||
conditional formatting with blank date fields | Excel Worksheet Functions | |||
put zero in blank cell using conditional formatting | Excel Worksheet Functions | |||
conditional formatting blank cell | Excel Discussion (Misc queries) |