Complex cond. formatting...Pls. Help!
 

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
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=494970

Complex cond. formatting...Pls. Help!
 

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

On Tue, 20 Dec 2005 12:57:21 -0600, Roz
wrote:


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.