Conditional Formatting

[ibrindley]

I am trying to create a conditional format on a cell using two conditions:

The Value of a Date in the active cell is not > TODAY and the value "No" is present another cell. I have tried:

=(((D13-TODAY())<1) and (F3="No"))
This message was edited by ibrindley on 2002-09-15 06:55
This message was edited by ibrindley on 2002-09-15 06:56

 

[sen_edp]

Hello

try this formula

=(d13<=today())*(f3="No")


hth

 

[ibrindley]

On 2002-09-15 07:06, sen_edp wrote:
Hello

try this formula

=(d13<=today())*(f3="No")


hth