HELP with IF Statement - PLEASE

[Lauren Tatulli]

I'm trying to create a simple formula for someone that needs an 'IF Statement.' I want to say, IF cell G3 is blank or 3 days past the date in cell F3, then show date/blank red fill in cell G3. IF G3 has date received within 3 days of date in cell F3, show date and green in cell G3.

 

[NARAYANK991]

Hi ,

Both of the things that you want cannot be done using only formulae.

Secondly , you cannot have both user data entry and Excel's output in the same cell using formulae. If you want that the user should be able to enter a date in G3 , and that Excel should also be able to enter a date in G3 if it is blank , then only VBA can do the job.

Narayan

 

[pecoflyer]

Looks more like conditional formatting as I understand it ?

 

[NARAYANK991]

Looks more like conditional formatting as I understand it ?

Hi ,

CF will colour the cells appropriately , but I am not clear on what G3 will contain and how ; will it be user data entry or formula or ... ?

Narayan

 

[Lauren Tatulli]

G3 will contain a date (3/30/18). G column represents dates that part for a job are received. I would like the row or specific cell to be red, if the part has not been received (BLANK cell) or has not been received within 3 days of ordering (3/30/18 + 3) or green if it has been received and within 3 days of ordering.

3 columns
E - Date of Job In
F - Date of Part Ordered
G - Date of Part Received.

 

[Lauren Tatulli]

I can create color for row, a specific cell or anywhere. Just need to be able to indicate which job can proceed, because all parts are received and on time.

Thank you!!

 

[pecoflyer]

I suggest you post a sample file with some data and expected results ( no pics plesase)

 

[NARAYANK991]

Hi ,

Select your range , say G3:G20 , and enter the following formula in the CF rule box :

=AND($F3 <> "", OR($G3 = "", $G3 > ($F3 + 3)))

Select the color RED.

Enter the following formula in a second CF rule box :

=AND($F3 <> "", $G3 <> "", $G3 <= ($F3 + 3))

Select the color GREEN.

Narayan

 

[Lauren Tatulli]

What I am trying to do is attached.

In the meantime, I will work with the suggestion mentioned above.

Thank you all!

 

[Lauren Tatulli]

The red worked in example above, but how do I do it again for green in another CF box,without overruling the red?

 

[Lauren Tatulli]

IT WORKED!!! You all are amazing!!! THANK YOU!

 

[Lauren Tatulli]

So ultimately, now they are saying they need this. And this need this to be on-going throughout the spreadsheet, even when they add jobs. I've attached their explanation.

Thank you!

 

[NARAYANK991]

Hi ,

Please post your workbook with enough data in it.

Narayan

 

[Lauren Tatulli]

I posted with all that I was given. There are notes in the sheet explaining what needs to be done. I just don't know the formula. I'd imagine it would be similar to the formula provided above.

 

[Lauren Tatulli]

How do I get this to set for the entire worksheet?

Hi ,

Select your range , say G3:G20 , and enter the following formula in the CF rule box :

=AND($F3 <> "", OR($G3 = "", $G3 > ($F3 + 3)))

Select the color RED.

Enter the following formula in a second CF rule box :

=AND($F3 <> "", $G3 <> "", $G3 <= ($F3 + 3))

Select the color GREEN.

Narayan

 

[Lauren Tatulli]

Looking for formula to read:

IF cells in column E, starting with E3, are blank or 3 days greater than today (in cell B1), red. If within 3 days of today, green.

Then i need to so the same for column F, starting F3 and column G, starting G3.

Thank you!