I have many many cells in which to enter Conditional Formatting.

All I have been able to do is enter code into one cell at a time.

Am I able to copy and paste the conditional formatting into other 'many' cells, and have the 'new cells' be the one which contain the formatting, relative to each new cell?

I have tried the copy & paste, running a macro, dragging the cells, formatted many cells all at once - all without success.

I still have around 300 cells in which to enter conditional formatting and a good 5+ hours of shoulder aching data input.

am using the following formula - =isblank(cell)=false then format the range of cells required.

Any help appreciated.