Conditional Formatting (only until field is populated)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Marcy said:
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
Click to expand...
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
Click to expand...
cell stays red even after the cell is populated.
 
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)

Marcy said:
Bob,

This didn't work...
Here's the recap. Cell C22 will have a date (e.g., 4/19/04) that info is
Click to expand...
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
Click to expand...
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.
 
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

Marcy said:
Bob
Here's the recap. Cell C22 will have a date (e.g., 4/19/04) that info i
Click to expand...
passed to be able to create a PO
Cell N22 will have the PO number once it is written
Click to expand...
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
 
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)

marcy said:
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
Click to expand...
come into play when there is a date in C22?
 
Back
Top