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

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

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

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

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

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

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