some kind of Conditional format? - Baffled :(

D

Dave

Hi all,

I've got an issue where I need a formula that when I put a date (or any
value) in cell A1, the text 'Closed' is automatically entered in cell B1
- I'm sure I've seen it somewhere before (probably used it too), but
I've searched in vain - can anyone help?

TIA


Dave
 
D

David Biddulph

Not conditional format, but in B1 you can use the formula
=IF(A1="","","Closed")
 
D

David Biddulph

Or you could shorten that to =IF(LEN(A1)>0,"Closed",""), as it is unlikely
that LEN will be negative. :)
 
D

Dave

Hi all,

I've got an issue where I need a formula that when I put a date (or any
value) in cell A1, the text 'Closed' is automatically entered in cell B1
- I'm sure I've seen it somewhere before (probably used it too), but
I've searched in vain - can anyone help?

TIA


Dave
Click to expand...

Thank you for your help gentlemen - I now feel rather stupid :(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Conundrum 3
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks" 1
Need Help 4
setting cell values based on a 3rd cell 4
IF OR AND in same conditional formula 2
Missing default cell styles on some large existing spreadsheets 0
conditional format help please 6
Using colour conditional formatting to show whether due date has past 0

Top