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

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

.. 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

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

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

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 :)

"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
---

:-) 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
---