writing in a blank cell

[paramnayak]

hi all,
I want a set of blank cells to give this message "no data entered".

Using conditional formatting , i can colour the blank cells but i am not able to put "no data entered".

Is there any way by which i can achieve this.

thanks and rgds

 

[Khalid NGO]

Hi @paramnayak

I had the similar issue few years ago, I found that we can change the background etc with Conditional formatting, but we can Not change the cell format for Blank Cells. [except there is a way in VBA]

I have found a cheat here:
http://superuser.com/questions/2061...out-using-conditional-formattin/206182#206182

Regards,

 

[bobhc]

You could do this,

=IF(LEN(A2)>0,A2,"No data entered")

or this
=IF(A2<>"",A2,"No data entered")

or maybe this is the one you want !
=IF(ISBLANK(A2),"No data entered",A2)


Just put your cell reference in, I start at A2 because EVERYBODY uses the first row for understandable column titles and EVERYBODY names their sheet tabs....NOT.

If you turn your data into a table the formula will auto fill down without CF, if you still want CF just CF for text cells. Look at the file upload.

.