First condition (7 days past due)

=And($B$1$F6,$B$1<=($F6+7)) - format yellow

Second condition

=$B$1($F6+7) - format red

To make the whole row turn red (or yellow), select all the cells in the row
you want to be formatted this way AND THEN do the conditional formatting



"Oddcarout" wrote:

redid my formula
=IF($B$1<F6,"Current",IF($B$1-7F6,"7 Days Past Due", IF($B$1F6,"Past
Due",unknown)))

I have added the 7 days past due, I would like to use two different colors,
one for past due and one for 7 days past due.

Thanks