=if(isblank

[berger01]

I have a Date cell “Start Date” that users paste data (Paste Values) into. Sometimes the data in this cell is empty.

In this Start Date cell, I want the user to be able to paste the data, but if there is not a date pasted, I want that cell to capture another date "Org Date" (that is always populated) in the Start Date cell. If data is pasted into the Start Date cell, then that data is used and the formula is ignored.

Lastly, (conditional formatting). I'd like the Start Date cell to somehow show that it had to use the Org Date.

Any methodology on this to get me going would be greatly appreciated.

Thanks

[NBVC]

You can't have 2 options for a cell (i.e paste or get value from another cell)... it is one or the other.

What you can do is have the user paste into a different cell, and if that cell is blank then get that other date.

e.g. =IF(X1="",Y1,X1)

where X1 is the cell the user pastes a value into.... and if it is blank, then the formula takes the value in Y1 instead.

For conditional formatting you can select that cell and go to Formulas|Conditional formatting|New Rule.

And select Format only cells that contain from top section and then select, Cell Value >> Equal To and enter =Y1

then click Format and choose colour from Fill tab.

This will colour the cell if it is equal to Y1 (where the "Org Date" is)

[berger01]

Ok, I found another way to do this.... I think. Thanks for your expertise.