Complex cond. formatting...Pls. Help!

  • Thread starter Thread starter Roz
  • Start date Start date
R

Roz

Hi again! I have a cell in excel that has this formula:
=AND(E3<D3,TODAY()>G3). I sometimes need E3 to display something like
3+1, meaning that I received two different shipments. I want excel to
be able to calculate the 3+1, while still performing the formula
mentioned above. I don't need excel to display the answer to 3+1, but
I need it to know the answer and recognize that 3+1 received items is
equal to the 4 items ordered. Thanks.
 
Roz

Using a UDF you can evaluate E3 to 4 if it has 3+1 entered.

Function EvalCell(RefCell As String)
Application.Volatile
EvalCell = Evaluate(RefCell)
End Function

Copy/paste to a general module in your workbook.

CF formula =AND(EvalCell(E3)<D3,TODAY()>G3)


Gord Dibben Excel MVP
 
Back
Top