Conditional Formatting

ibrindley

New Member
Joined
Sep 14, 2002
Messages
20
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
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,652
Members
412,335
Latest member
cinciri99
Top