Auto Format painter on below rows as of above

[rahat.ir]

Hi,

I have an excel sheet with formatting which I want but when I copy data from any other source I have to use format painter again and again manually. Is there any solution that when we paste data in new rows it automatically formats data as formatted on above rows.

[davsth]

Yes there are solutions, perhaps conditional formatting or a vba solution, but without a spreadsheet showing what you want, you will get a vague answer

[Pete_UK]

Instead of Copy/Paste for the new data, you should use Paste Special, where you can choose to paste Values only and this will not affect the underlying formatting.

Hope this helps.

Pete

[rahat.ir]

Hi,

Apologies for replying late. Attached is a sample file. Now, what I need is that I copied same data from a web page and copy on row 4. I want that data to be copied automatically as the same format as above row. Don't want to do format painter every time I copy data.

Hope you understand.

[davsth]

Is all you are wanting a blue background in the cells in column D if they are not empty?

Select the cells, it could be column D or say d1:d1000
Conditional formatting_New rule_use a formula to determine which cells to format
put in the formula=isblank(d1)=false and choose your background colour as the fill

sometimes excel put " around the formula, if it does this you need to delete them