Conditional Formatting Question

[football9673]

I am new to this website so I apologize if this has already been answered. The spread sheet I am working on contains more information then these cells but they are the reference cells for the conditional formatting I am trying to accomplish.

So I need to do a type of conditional formatting as follows:

If the strength cell is blank (B cells) and it has been 28 days since the date placed (A cells). The blank cell should turn red and display the term "MISSING". If the cell is not blank the cell should have no conditional formatting and simply display the value entered in the cell. If it has not been more then 28 days and the strength cell is still blank there should be no conditional formatting applied to the cell.

The table below displays what I am trying to create; the B3 cell is correct and thus should display the 5000 value placed in that cell after the formatting. The B4 cell has exceeded the 28 days and is still blank, and thus I would like the conditional formatting to fill that cell in with the phrase "MISSING", and fill the cell with the color red. The same conditional formatting to this column of cells should also leave cell B5 alone since the 28 days has not been surpassed yet. I am having trouble determining how to make this work for my excel spread sheet (Do I need multiple rules? Is there a simpler solution for the problem I am trying to solve?). Any help would be greatly appreciated


[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Date Placed[/TD]
[TD]Strength of Concrete[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]7/5/15[/TD]
[TD]5000[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]7/5/15[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]8/20/15[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Chrisdontm]

I have the rule for filling the cell in with a color...

Highlight Cell # B3 and all the way down however far down you want to go, then make a new rule with this formula;

=IF(AND(A3<=(TODAY()-28),B3="",A3>0),TRUE,FALSE)

As for the word " Missing ", you could set a formula to put it there, but you would have to leave that formula alone and not enter anything into that cell...

The other choice would be with VBA, but I am not too good with VBA...

I hope this helps some..