excel - Highlight row of current data range and calculate target to date -
how use conditional formatting highlight row value in column c falls within date range (i.e. present week).
for example in current example, week 4 highlighted (because today's date falls in between 21 mar , 28 mar.
secondly how add values in b date cell b12?
for example in case value include values in cell b until 21 march (last weeks date) - 745.
conditional formatting:
you use following in formula box when create conditional format , apply range a3:c10. :
=and($c3>today(),$c3-7<today())
sum date:
=sumif(c3:c10,"<"&today(),b3:b10)
Comments
Post a Comment