Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CONDITIONAL FORMULA
IS IT POSSIBLE TO WRITE A CONDITIONAL FORMULA WHERE THE LOGICAL CONDITION IS
EITHER A BLANK CELL OR A DATE? THEN, IF THAT IS POSSIBLE CAN TRUE BE A COPY COMMAND AND FALSE A DOWN ONE CELL COMMAND? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CONDITIONAL FORMULA
Hello,
Try the following: Sub Conditional() With Range("a1") If IsDate(.Value) Or .Value = vbNullString Then .Copy .Item(1, 2) Else: .Item(2).Select End If End With End Sub Where .Item(1, 2) is one cell to the right. Regards, Nate Oliver |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
Multiple conditional on conditional format formula | Excel Programming | |||
Multiple conditional on conditional format formula | Excel Programming |