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.

enter image description here

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

Popular posts from this blog

android - Get AccessToken using signpost OAuth without opening a browser (Two legged Oauth) -

org.mockito.exceptions.misusing.InvalidUseOfMatchersException: mockito -

google shop client API returns 400 bad request error while adding an item -