Add conditional formatting when new data is entered at bottom of range

[kmlloyd]

Is there a way to have conditional formatting automatically extend to new rows when data is entered?

I'm using =MOD(ROW(),2)=1 to colour every other row and it's working great, except when I need to add more data to the bottom of the existing data set. The tutorial I watched said "if you add more data to the list, the conditional formatting is extended to rows beyond" which it is not.

this is a huge data set that could be used to add data for years to come, so I don't really want to add it to a huge amount of rows right now just in case...is there a way to make this dynamic so it will copy the conditional formatting automatically?

I've seen this done with other formatting, like borders, font format, etc...without using VBA...hoping there's something I can do here.

TIA!

[GeneralDisarray]

Just make a different rule to check for 'new data' - probably just check to see if a certain cell is blank.

Like: =(MOD(ROW(),2)=1)*($A1<>"")

Now, you would need to edit the $A1 part to match whichever row you were actually making the edit on. Then you just extend your conditional formatting for the entire column.


See attached example.

[kmlloyd]

Gotcha! That's genius, thanks so much!!!

[GeneralDisarray]

no problem