Conditional Formatting (only until field is populated)

[Guest]

Good morning

Can someone please tell me the formula for CF for the following criteria

1. Cell $N22 will be a PO
2. Date info passed to create PO is in cell $C22
3. If the date in $C22 is greater than 3 days from today and cell $N22 still doesn't have a PO# assigned, the cell should turn RED
4. But, once the field is populated with a date, the field should have no fill or no CF

So far, I have =If(isblank($C22),"",(TODAY()-$C22)>=3) but this way the cell stays red even after the cell is populated

Looking forward to your much needed guidance
Thanks!

 

[Bob Phillips]

I got confused with what is where, but here goes (untested)

=AND(N22<>"",TODAY()-C22>-3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Good morning,

Can someone please tell me the formula for CF for the following criteria:

1. Cell $N22 will be a PO#
2. Date info passed to create PO is in cell $C22.
3. If the date in $C22 is greater than 3 days from today and cell $N22

still doesn't have a PO# assigned, the cell should turn RED.

4. But, once the field is populated with a date, the field should have no fill or no CF.

So far, I have =If(isblank($C22),"",(TODAY()-$C22)>=3) but this way the

cell stays red even after the cell is populated.

 

[Bob Phillips]

Marcy,

I also made a mistake.

Does this one work?

=AND(N22="",TODAY()-C22>=3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Bob,

This didn't work...
Here's the recap. Cell C22 will have a date (e.g., 4/19/04) that info is

passed to be able to create a PO.

Cell N22 will have the PO number once it is written.

However, if Cell C22 has 4/19/04 and N22 is still empty after 3 days have

passed from the time (in this case, from 4/19 til now, then this would be
late and CF would apply) then the cell should have a red fill.

 

[Guest]

One more problem with this~
If C22 is empty, the cell in N22 is using the CF

how can I make it understand that the formula you provided should only come into play when there is a date in C22

Don't give up on me yet, Bob. I'm almost there

----- Bob Phillips wrote: ----

Marcy

I also made a mistake

Does this one work

=AND(N22="",TODAY()-C22>=3

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

Bob
Here's the recap. Cell C22 will have a date (e.g., 4/19/04) that info i

passed to be able to create a PO

Cell N22 will have the PO number once it is written

passed from the time (in this case, from 4/19 til now, then this would b
late and CF would apply) then the cell should have a red fill

 

[Bob Phillips]

Ok Marcy,

Version 2.01/XVI/.001/27/SR2.001

=AND(N22="",C22<>"",TODAY()-C22>=3)

should have thought of that

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

One more problem with this~~
If C22 is empty, the cell in N22 is using the CF.

how can I make it understand that the formula you provided should only

come into play when there is a date in C22?

 

[Guest]

Version 2.01/XVI/.001/27/SR2.001 is ready for publication!

thanks so much!

 

[Bob Phillips]

Let's give it a production number then, 3<vbg>

Glad we made it.

Bob