Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
I am having trouble with the conditional formatting, I need to have the
review dates highlighted, if they are past due, I want to use the date of 11/1/08. do I need to have the whole column formated for dates then use conditional formatting? example column a review date employee name 12/1/08 employee name 6/1/08 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Youneeed to compare two serialdates with each other like below. DateValue()
will convert you string date "11/1/08" to a serialdate. =TODAY()A1 or =DateValue("11/1/08")A1 "nativeutah" wrote: I am having trouble with the conditional formatting, I need to have the review dates highlighted, if they are past due, I want to use the date of 11/1/08. do I need to have the whole column formated for dates then use conditional formatting? example column a review date employee name 12/1/08 employee name 6/1/08 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
I tried this and I still can't get it to work, my review date is in column d,
I used conditonal formatting - cell value is - less than - then I tried =DateValue("11/1/08")A1 but it turn my whole column red, I only want dates that are lower than 11/108 to turn red. "Joel" wrote: Youneeed to compare two serialdates with each other like below. DateValue() will convert you string date "11/1/08" to a serialdate. =TODAY()A1 or =DateValue("11/1/08")A1 "nativeutah" wrote: I am having trouble with the conditional formatting, I need to have the review dates highlighted, if they are past due, I want to use the date of 11/1/08. do I need to have the whole column formated for dates then use conditional formatting? example column a review date employee name 12/1/08 employee name 6/1/08 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Use D1 instead of A1? The row number should be the same row as you arte
putting the conditional formating. =DateValue("11/1/08")D1 "nativeutah" wrote: I tried this and I still can't get it to work, my review date is in column d, I used conditonal formatting - cell value is - less than - then I tried =DateValue("11/1/08")A1 but it turn my whole column red, I only want dates that are lower than 11/108 to turn red. "Joel" wrote: Youneeed to compare two serialdates with each other like below. DateValue() will convert you string date "11/1/08" to a serialdate. =TODAY()A1 or =DateValue("11/1/08")A1 "nativeutah" wrote: I am having trouble with the conditional formatting, I need to have the review dates highlighted, if they are past due, I want to use the date of 11/1/08. do I need to have the whole column formated for dates then use conditional formatting? example column a review date employee name 12/1/08 employee name 6/1/08 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
ok I am getting frustrated, i used d1 but it still turns dates that are above
11/1/08 red. "Joel" wrote: Use D1 instead of A1? The row number should be the same row as you arte putting the conditional formating. =DateValue("11/1/08")D1 "nativeutah" wrote: I tried this and I still can't get it to work, my review date is in column d, I used conditonal formatting - cell value is - less than - then I tried =DateValue("11/1/08")A1 but it turn my whole column red, I only want dates that are lower than 11/108 to turn red. "Joel" wrote: Youneeed to compare two serialdates with each other like below. DateValue() will convert you string date "11/1/08" to a serialdate. =TODAY()A1 or =DateValue("11/1/08")A1 "nativeutah" wrote: I am having trouble with the conditional formatting, I need to have the review dates highlighted, if they are past due, I want to use the date of 11/1/08. do I need to have the whole column formated for dates then use conditional formatting? example column a review date employee name 12/1/08 employee name 6/1/08 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Check an make sure column D data is really a date. Click on a Row in column
D on one of the dates that should be highlighted. Then go to format - Cells - Number and see if Dates is highlighted. If not, change format to a date format. Also make sure there are no extra spaces before the date and after the date in the cell. "nativeutah" wrote: ok I am getting frustrated, i used d1 but it still turns dates that are above 11/1/08 red. "Joel" wrote: Use D1 instead of A1? The row number should be the same row as you arte putting the conditional formating. =DateValue("11/1/08")D1 "nativeutah" wrote: I tried this and I still can't get it to work, my review date is in column d, I used conditonal formatting - cell value is - less than - then I tried =DateValue("11/1/08")A1 but it turn my whole column red, I only want dates that are lower than 11/108 to turn red. "Joel" wrote: Youneeed to compare two serialdates with each other like below. DateValue() will convert you string date "11/1/08" to a serialdate. =TODAY()A1 or =DateValue("11/1/08")A1 "nativeutah" wrote: I am having trouble with the conditional formatting, I need to have the review dates highlighted, if they are past due, I want to use the date of 11/1/08. do I need to have the whole column formated for dates then use conditional formatting? example column a review date employee name 12/1/08 employee name 6/1/08 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Format col d as date
select the whole col by clicking the 'd' select'conditional formatting'<''highlight cells rules'<'lessthan' input date 11/01/08 in box select format ok if you manage to get up to date there's a similar way to highlight days 'older' than today or yesterday etc "nativeutah" wrote: I tried this and I still can't get it to work, my review date is in column d, I used conditonal formatting - cell value is - less than - then I tried =DateValue("11/1/08")A1 but it turn my whole column red, I only want dates that are lower than 11/108 to turn red. "Joel" wrote: Youneeed to compare two serialdates with each other like below. DateValue() will convert you string date "11/1/08" to a serialdate. =TODAY()A1 or =DateValue("11/1/08")A1 "nativeutah" wrote: I am having trouble with the conditional formatting, I need to have the review dates highlighted, if they are past due, I want to use the date of 11/1/08. do I need to have the whole column formated for dates then use conditional formatting? example column a review date employee name 12/1/08 employee name 6/1/08 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | 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 based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |