Conditional Format Based on Age, but not if blank.
 

I was to apply conditional formating to a cell. In that cell is a date,
formatted as 3/28/2008.

The Conditional Formating should look at the date, if that date is 180 days
or more in the past, it should fill the cell with yellow. If the cell is
blank, it shouldbe left as is.

I have gotten the 180 day part to work with "Cell value is, less than or
equal to, =(TODAY()-180)"

But a blank cell is also "less than or equal to". How can I make it leave a
blank cell alone?
--
Thank you,

Gregory

Conditional Format Based on Age, but not if blank.
 

In the CF dialogue box select Formula Is rather than Cell Value Is,
and enter this formula:

=AND(A1<"",A1<=TODAY()-180)

assuming the cell in question is A1 - adjust to suit.

Hope this helps.

Pete

On Mar 28, 7:45*pm, Gregory Day
wrote:
I was to apply conditional formating to a cell. In that cell is a date,
formatted as 3/28/2008.

The Conditional Formating should look at the date, if that date is 180 days
or more in the past, it should fill the cell with yellow. If the cell is
blank, it shouldbe left as is.

I have gotten the 180 day part to work with "Cell value is, less than or
equal to, =(TODAY()-180)"

But a blank cell is also "less than or equal to". How can I make it leave a
blank cell alone?
--
Thank you,

Gregory

Conditional Format Based on Age, but not if blank.
 

That was AWESOME. Thank you!
--
Thank you,

Gregory


"Pete_UK" wrote:

In the CF dialogue box select Formula Is rather than Cell Value Is,
and enter this formula:

=AND(A1<"",A1<=TODAY()-180)

assuming the cell in question is A1 - adjust to suit.

Hope this helps.

Pete

On Mar 28, 7:45 pm, Gregory Day
wrote:
I was to apply conditional formating to a cell. In that cell is a date,
formatted as 3/28/2008.

The Conditional Formating should look at the date, if that date is 180 days
or more in the past, it should fill the cell with yellow. If the cell is
blank, it shouldbe left as is.

I have gotten the 180 day part to work with "Cell value is, less than or
equal to, =(TODAY()-180)"

But a blank cell is also "less than or equal to". How can I make it leave a
blank cell alone?
--
Thank you,

Gregory

Conditional Format Based on Age, but not if blank.
 

You're welcome - thanks for feeding back.

Pete

On Mar 28, 8:43*pm, Gregory Day
wrote:
That was AWESOME. Thank you!
--
Thank you,

Gregory



"Pete_UK" wrote:
In the CF dialogue box select Formula Is rather than Cell Value Is,
and enter this formula:

=AND(A1<"",A1<=TODAY()-180)

assuming the cell in question is A1 - adjust to suit.

Hope this helps.

Pete

On Mar 28, 7:45 pm, Gregory Day
wrote:
I was to apply conditional formating to a cell. In that cell is a date,
formatted as 3/28/2008.

The Conditional Formating should look at the date, if that date is 180 days
or more in the past, it should fill the cell with yellow. If the cell is
blank, it shouldbe left as is.

I have gotten the 180 day part to work with "Cell value is, less than or
equal to, =(TODAY()-180)"

But a blank cell is also "less than or equal to". How can I make it leave a
blank cell alone?
--
Thank you,

Gregory- Hide quoted text -

- Show quoted text -

Conditional Format Based on Age, but not if blank.
 

One more thing if I may. That Formatting was on Sheet2!. I would like to add
a cell on Sheet1! that looks at that column and counts the number of entries
that are 180 or higher. Remember, the column contains dates. I tried this:

=COUNTIF(Clients!AC4:AC113,(TODAY()-180))

but it just gave me 0 thought there was 1 in the column.

If you can assit, Thank you. If not, I thank you anyway just for being so
helpful to start with.
--
Thank you,

Gregory


"Pete_UK" wrote:

You're welcome - thanks for feeding back.

Pete

On Mar 28, 8:43 pm, Gregory Day
wrote:
That was AWESOME. Thank you!
--
Thank you,

Gregory



"Pete_UK" wrote:
In the CF dialogue box select Formula Is rather than Cell Value Is,
and enter this formula:

=AND(A1<"",A1<=TODAY()-180)

assuming the cell in question is A1 - adjust to suit.

Hope this helps.

Pete

On Mar 28, 7:45 pm, Gregory Day
wrote:
I was to apply conditional formating to a cell. In that cell is a date,
formatted as 3/28/2008.

The Conditional Formating should look at the date, if that date is 180 days
or more in the past, it should fill the cell with yellow. If the cell is
blank, it shouldbe left as is.

I have gotten the 180 day part to work with "Cell value is, less than or
equal to, =(TODAY()-180)"

But a blank cell is also "less than or equal to". How can I make it leave a
blank cell alone?
--
Thank you,

Gregory- Hide quoted text -

- Show quoted text -

Conditional Format Based on Age, but not if blank.
 

Try it like this:

=COUNTIF(Clients!AC4:AC113,"<="&(TODAY()-180))

Hope this helps.

Pete

On Mar 28, 9:14*pm, Gregory Day
wrote:
One more thing if I may. That Formatting was on Sheet2!. I would like to add
a cell on Sheet1! that looks at that column and counts the number of entries
that are 180 or higher. Remember, the column contains dates. I tried this:

=COUNTIF(Clients!AC4:AC113,(TODAY()-180))

but it just gave me 0 thought there was 1 in the column.

If you can assit, Thank you. If not, I thank you anyway just for being so
helpful to start with.
--
Thank you,

Gregory



"Pete_UK" wrote:
You're welcome - thanks for feeding back.

Pete

On Mar 28, 8:43 pm, Gregory Day
wrote:
That was AWESOME. Thank you!
--
Thank you,

Gregory

"Pete_UK" wrote:
In the CF dialogue box select Formula Is rather than Cell Value Is,
and enter this formula:

=AND(A1<"",A1<=TODAY()-180)

assuming the cell in question is A1 - adjust to suit.

Hope this helps.

Pete

On Mar 28, 7:45 pm, Gregory Day
wrote:
I was to apply conditional formating to a cell. In that cell is a date,
formatted as 3/28/2008.

The Conditional Formating should look at the date, if that date is 180 days
or more in the past, it should fill the cell with yellow. If the cell is
blank, it shouldbe left as is.

I have gotten the 180 day part to work with "Cell value is, less than or
equal to, =(TODAY()-180)"

But a blank cell is also "less than or equal to". How can I make it leave a
blank cell alone?
--
Thank you,

Gregory- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Conditional Format Based on Age, but not if blank.
 

Oh you ARE the man! Thank you!
--
Thank you,

Gregory


"Pete_UK" wrote:

Try it like this:

=COUNTIF(Clients!AC4:AC113,"<="&(TODAY()-180))

Hope this helps.

Pete

On Mar 28, 9:14 pm, Gregory Day
wrote:
One more thing if I may. That Formatting was on Sheet2!. I would like to add
a cell on Sheet1! that looks at that column and counts the number of entries
that are 180 or higher. Remember, the column contains dates. I tried this:

=COUNTIF(Clients!AC4:AC113,(TODAY()-180))

but it just gave me 0 thought there was 1 in the column.

If you can assit, Thank you. If not, I thank you anyway just for being so
helpful to start with.
--
Thank you,

Gregory



"Pete_UK" wrote:
You're welcome - thanks for feeding back.

Pete

On Mar 28, 8:43 pm, Gregory Day
wrote:
That was AWESOME. Thank you!
--
Thank you,

Gregory

"Pete_UK" wrote:
In the CF dialogue box select Formula Is rather than Cell Value Is,
and enter this formula:

=AND(A1<"",A1<=TODAY()-180)

assuming the cell in question is A1 - adjust to suit.

Hope this helps.

Pete

On Mar 28, 7:45 pm, Gregory Day
wrote:
I was to apply conditional formating to a cell. In that cell is a date,
formatted as 3/28/2008.

The Conditional Formating should look at the date, if that date is 180 days
or more in the past, it should fill the cell with yellow. If the cell is
blank, it shouldbe left as is.

I have gotten the 180 day part to work with "Cell value is, less than or
equal to, =(TODAY()-180)"

But a blank cell is also "less than or equal to". How can I make it leave a
blank cell alone?
--
Thank you,

Gregory- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Conditional Format Based on Age, but not if blank.
 

Glad to be of help - cheers.

Pete

On Mar 28, 10:15*pm, Gregory Day
wrote:
Oh you ARE the man! Thank you!
--
Thank you,

Gregory



"Pete_UK" wrote:
Try it like this:

=COUNTIF(Clients!AC4:AC113,"<="&(TODAY()-180))

Hope this helps.

Pete

On Mar 28, 9:14 pm, Gregory Day
wrote:
One more thing if I may. That Formatting was on Sheet2!. I would like to add
a cell on Sheet1! that looks at that column and counts the number of entries
that are 180 or higher. Remember, the column contains dates. I tried this:

=COUNTIF(Clients!AC4:AC113,(TODAY()-180))

but it just gave me 0 thought there was 1 in the column.

If you can assit, Thank you. If not, I thank you anyway just for being so
helpful to start with.
--
Thank you,

Gregory

"Pete_UK" wrote:
You're welcome - thanks for feeding back.

Pete

On Mar 28, 8:43 pm, Gregory Day
wrote:
That was AWESOME. Thank you!
--
Thank you,

Gregory

"Pete_UK" wrote:
In the CF dialogue box select Formula Is rather than Cell Value Is,
and enter this formula:

=AND(A1<"",A1<=TODAY()-180)

assuming the cell in question is A1 - adjust to suit.

Hope this helps.

Pete

On Mar 28, 7:45 pm, Gregory Day
wrote:
I was to apply conditional formating to a cell. In that cell is a date,
formatted as 3/28/2008.

The Conditional Formating should look at the date, if that date is 180 days
or more in the past, it should fill the cell with yellow. If the cell is
blank, it shouldbe left as is.

I have gotten the 180 day part to work with "Cell value is, less than or
equal to, =(TODAY()-180)"

But a blank cell is also "less than or equal to". How can I make it leave a
blank cell alone?
--
Thank you,

Gregory- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -