How to highlight rows for each individual date?

Question

excel

I have a spreadsheet with expenses. Each expense is a separate line. There can be up to 10 lines per day, for example.
In order not to get confused in a lot of lines, I want to highlight a block of lines with a color every other day. I made a manual example:

I want this result, but only automated. How can I implement this?

Answer 1

We use 2 formulas. for even and odd days:
=AND(MOD($A1,2)=1,LEN($A1)>0)
=AND(MOD($A1,2)=0,LEXT($A1)>0)
How to use : select the
necessary columns that you want to colorize,
click Conditional Formatting - Create Rule
Select the section "Use a formula to determine formatted cells"
Insert the formula there.
Instead of $A1, you can specify the required cell by which the coloring will be determined.
DLSTR($A1)>0 is necessary in order not to fill in empty cells, so you can select entire columns directly, and not a specific range.
Set the required formatting for each formula.
you can use only one formula, then only even (or odd) lines will be painted over.

Screenshots

Answer 2

google "conditional formatting"