Insert space between each line in CF

Hi excel!

I'm new to this forum and i would like to learn as much as i can!
Here is my first question, i have a spreadsheet which has a CF going down 1000 rows which switches colors once i enter a value in that cell. The thing here is that i want to enter notes right underneath that cell but i don't want that cell to switch colors, is there a way to insert a space between each cell and not have to do it manually?

Any insight on this issue would be greatly appreciated.

Thanks in advance!

Hi and welcome to the forum!

What you need to do is enter the first cell with the conditional formula that you want, then select that cell and the empty cell underneath and move your curser to the bottom right hand corner of the selected cell where a plus sign will appear and drag it down as many rows as you like and you should have a space between each cell.

Hope this works.

Originally Posted by FDibbins

Hi and welcome to the forum

Maybe try this...
Start your notes with the word "Note", and then include something like this in your CF rule...
=AND($A2<>"note",your-CF-formula)

Thank you Ford for your help and thanks for welcoming me. I hope to learn a lot from this site.
The thing here is that i want to enter any word not necessarily the word "note". I have a similar formula to Kosherboy's (Kosherboy, i'm going to try your answer in a minute:-) ). It's like this =not(isblank($U6)) but i'm not sure how to plug it in, the color still gets formulated when i enter a value on the cell underneath?

I would appreciate very much if you can modify my formula.

Thanks in advance:-)

Originally Posted by kosherboy

Hi and welcome to the forum!

What you need to do is enter the first cell with the conditional formula that you want, then select that cell and the empty cell underneath and move your curser to the bottom right hand corner of the selected cell where a plus sign will appear and drag it down as many rows as you like and you should have a space between each cell.

Hope this works.

Thank you kosherboy for welcoming me! And thank you for your reply... YOUR SYSTEM WORKED TO PERFECTION! WOW! UNBELIEVABLE! I'm going to spread this trick to all my co-workers!
Thanks again!