How to automatically bordered cell as it filled with data?

[naro1705]

Hello all

I want to border individual cell as that cell filled with data with vba code or by condition formating. I have tried by condition formatting but its still stuck like want more knowledge . please help me. Thanks in Advance.

 

[wigi]

Hello

I see quite a lot of hits on Google if I enter:
excel conditional formatting apply border

Seems to me that the solution for you is there.
If you are still stuck, post again and tell us what you tried.

 

[naro1705]

Hello

I see quite a lot of hits on Google if I enter:
excel conditional formatting apply border

Seems to me that the solution for you is there.
If you are still stuck, post again and tell us what you tried.

Thanks for reply

I have tried by condition formatting second time. And it's cool I have done it.

By setting condition formatting rule to blank cells.

Thanks & regards
Hiren