Good day,

Hoping someone can help…

In cell C4 I have percentage
In cell E4 I have a due date
In cell F4 I have calculated the number of days something is overdue
using this formula:
=DAYS360(TODAY(),E4)

What I would like to be able to do, is highlight the cells A4 to F4 if
C4 is less than 100 and F4 is less than 1.

Many thanks to whomever can help!