Conditional formatting highlighted by date range

Question

I tried my best to try to figure this out, this is due to conditional education in Excel. I want to find a way to highlight the following payment schedule based on the current date. Therefore, if today was February 10th, the next payment schedule will be February 15th and therefore will be highlighted. If today were February 16th, A6 and B6 would be highlighted.

Can anyone help me with a formula for this, I am assuming it is conditionally formatted using a formula. but the formula brings me down. this formula should apply to a large date range (600 dates)

Answer 1

Just try this formula:

=COUNTIFS($A$2:$A$9,"<="&$A2,$A$2:$A$9,">"&TODAY())=1

, , = :

=COUNTIFS($A$2:$A$9,"<="&$A2,$A$2:$A$9,">="&TODAY())=1

$ ( );)

( :

=$A2=MIN(IF($A$2:$A$9>TODAY(),$A$2:$A$9))

$A$2:$A$9>=TODAY()