CONDITIONAL FORMATTING- DATES
 

Hi all,

I am setting up conditional formatting to change the interior colour
for a row to red when a date passes. This I can do but I cannot figure
out how to not have the cells change when No date is input.

Any help appreciated

Thanks x

CONDITIONAL FORMATTING- DATES
 

use an AND formula

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Doo0592" wrote in message
ups.com...
Hi all,

I am setting up conditional formatting to change the interior colour
for a row to red when a date passes. This I can do but I cannot figure
out how to not have the cells change when No date is input.

Any help appreciated

Thanks x

CONDITIONAL FORMATTING- DATES
 

.. how to not have the cells change when No date is input.

Just set the condition to also check the date col for blank cells using an
AND(...). Eg something like this as condition 1:
Cond1: =AND($A1<"",$A1+2<TODAY())

The part: $A1<""
will ensure that the condition is not triggered for blank cells* in col A
(dates)
*or for formula cells returning: "" in col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Doo0592" wrote:
Hi all,

I am setting up conditional formatting to change the interior colour
for a row to red when a date passes. This I can do but I cannot figure
out how to not have the cells change when No date is input.

Any help appreciated

Thanks x

CONDITIONAL FORMATTING- DATES
 

Thanks folks :)


Max wrote:

.. how to not have the cells change when No date is input.

Just set the condition to also check the date col for blank cells using an
AND(...). Eg something like this as condition 1:
Cond1: =AND($A1<"",$A1+2<TODAY())

The part: $A1<""
will ensure that the condition is not triggered for blank cells* in col A
(dates)
*or for formula cells returning: "" in col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Doo0592" wrote:
Hi all,

I am setting up conditional formatting to change the interior colour
for a row to red when a date passes. This I can do but I cannot figure
out how to not have the cells change when No date is input.

Any help appreciated

Thanks x

CONDITIONAL FORMATTING- DATES
 

You're welcome.
Thanks for call-back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Doo0592" wrote:
Thanks folks :)

CONDITIONAL FORMATTING- DATES
 

Call-back?

"Max" wrote in message
...
You're welcome.
Thanks for call-back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Doo0592" wrote:
Thanks folks :)

CONDITIONAL FORMATTING- DATES
 

"Bob Phillips" wrote:
Call-back?
Not literally, of course. Just means "feedback"
It's for variety, Bob <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

CONDITIONAL FORMATTING- DATES
 

:-) I thought you had one of those odd spell-checker amendments.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Max" wrote in message
...
"Bob Phillips" wrote:
Call-back?
Not literally, of course. Just means "feedback"
It's for variety, Bob <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---