date row color

[john_cash]

Hello to all
in the attached workbook in column F there are dates
is it possible to color each row from column A:F for each date?
Example:
rows A3: F6 date 01/01/2020 yellow color
rows A7: F8 date 02/01/2020 pink color
rows A9: F10 date 02/01/2020 yellow color
rows A11: F1 date 03/01/2020 pink color
etc...
john

[Fluff13]

Select A3:F67 > conditional formatting > new rule > Use a formula > enter
=MOD(DAY($F3),2)=0
select a format

and the same again using
=MOD(DAY($F3),2)=1

[john_cash]

Hi fluff13 work well
And if column F is empty it doesn't have to be colored

[Fluff13]

Use
=AND($F3<>"",MOD(DAY($F3),2)=0)

The other formula can remain as-is.

[john_cash]

Hi fluff3 work well
A greeting
thanks
john

[Fluff13]

You're welcome & thanks for the feedback

[john_cash]

I noticed a small mistake
07/01/20
07/02/20
the day is the same but the month is not.
with formatting it comes out the same ones.
In this case it must be different

[Fluff13]

That's not a mistake, it did what you asked for with the data supplied

Try
=AND($F3<>"",MOD(SUMPRODUCT(--($F$2:$F2<>$F$3:$F3)),2)=0)
and
=AND($F3<>"",MOD(SUMPRODUCT(--($F$2:$F2<>$F$3:$F3)),2)=1)

[john_cash]

Thanks fluff13 it's o.k.
A greeting and thanks again
john

[Fluff13]

My pleasure.