H
hmsawyer
I already have the following formula in this cell but I also want to add that
if the sum is greater than or equal to 4, it will turn red and/or have a pop
up message. Any help is appreciated!
=SUMIF(C3:CE3,">=" & DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),E3:CE3)
if the sum is greater than or equal to 4, it will turn red and/or have a pop
up message. Any help is appreciated!
=SUMIF(C3:CE3,">=" & DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY())),E3:CE3)