Conditional Format carry over to next row in table

I a can't seem to get my conditional formatting to carry over to the next row. When I hit tab to go to the next row, The "H" cell automatically fills red and "G" doesn't format correctly. It's almost as if it is doing it's own thing. I do not want the cells to highlight unless there is a date in "H".

Is this the best way to do what I want to accomplish? This is the only way I know how.
Below are the conditional Formatting formulas

=AND(A5="LOE",TODAY()-H5<-16,TODAY()-H5>=-20)
=AND(A5="LOE",TODAY()-H5>=-16)
=AND(A4="AFAM",TODAY()-H4<-16,TODAY()-H4>=-20)
=AND(A4="AFAM",TODAY()-H4>=-16)
=AND(A4="AFCM",TODAY()-H4<-16,TODAY()-H4>=-20)
=AND(A4="AFCM",TODAY()-H4>=-16)
=AND(A4="MSM",TODAY()-H4<-20,TODAY()-H4>=-25)
=AND(A4="MSM",TODAY()-H4>=-20)


=AND(A5="LOE",TODAY()-H5<-10,TODAY()-H5>=-15)
=AND(A5="LOE",TODAY()-H5>=-10)
=AND(A5="AFAM",TODAY()-H5<-10,TODAY()-H5>=-15)
=AND(A5="AFAM",TODAY()-H5>=-10)
=AND(A5="AFCM",TODAY()-H5<-10,TODAY()-H5>=-15)
=AND(A5="AFCM",TODAY()-H5>=-10)
=AND(A5="MSM",TODAY()-H5<-15,TODAY()-H5>=-20)
=AND(A5="MSM",TODAY()-H5>=-15)

Thank you for any assistance.

Hi,

Please modify the formula adding an IF condition at the beginning: IF(H5<>"",condition,"")

eg:
=IF(H5<>"",AND(A5="LOE",TODAY()-H5<-10,TODAY()-H5>=-15),"")



Regards,
Chandra



Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.

I also have to add the ,"") at the end of each one correct?

yes, correct.

Thank you, I edited it, and it got rid of the colored blank cells, but my calculations aren't exactly working correctly now. For example, for the first line, Column F should turn yellow when it is within 10-15 days of the column H. And after the date has passed, the color disappears completely.

=IF(H5<>"",AND(A5="LOE",TODAY()-H5<-10,TODAY()-H5>=-15),"")
=IF(H5<>"",AND(A5="LOE",TODAY()-H5>=-10),"")
=IF(H5<>"",AND(A5="AFAM",TODAY()-H5<-10,TODAY()-H5>=-15),"")
=IF(H5<>"",AND(A5="AFAM",TODAY()-H5>=-10),"")
=IF(H5<>"",AND(A5="AFCM",TODAY()-H5<-10,TODAY()-H5>=-15),"")
=IF(H5<>"",AND(A5="AFCM",TODAY()-H5>=-10),"")
=IF(H5<>"",AND(A5="MSM",TODAY()-H5<-15,TODAY()-H5>=-20),"")
=IF(H5<>"",AND(A5="MSM",TODAY()-H5>=-15),"")


=IF(H5<>"",AND(A5="LOE",TODAY()-H5<-16,TODAY()-H5>=-20),"")
=IF(H5<>"",AND(A5="LOE",TODAY()-H5>=-16),"")
=IF(H5<>"",AND(A5="AFAM",TODAY()-H5<-16,TODAY()-H5>=-20),"")
=IF(H5<>"",AND(A5="AFAM",TODAY()-H5>=-16),"")
=IF(H5<>"",AND(A5="AFCM",TODAY()-H5<-16,TODAY()-H5>=-20),"")
=IF(H5<>"",AND(A5="AFCM",TODAY()-H5>=-16),"")
=IF(H5<>"",AND(A5="MSM",TODAY()-H5<-20,TODAY()-H5>=-25),"")
=IF(H5<>"",AND(A5="MSM",TODAY()-H5>=-20),"")

Please change the formula in the conditional formatting window if you want the background color to change, not in the formula bar.

I did add the formula in CF window, please see the updated version. If you play with the dates in the Dep Date cell, the formulas are not changing the color as it is stated in the condition Format formula

Again, thank you for assisting me