GoingmadwithExcel
New Member
- Joined
- Aug 20, 2015
- Messages
- 4
Hello,
I am using Excel to create a calendar and I am using the formula to highlight all cells between date.
[TABLE="width: 141"]
<tbody>[TR]
[TD="width: 141"]=AND(R$22>=$I23,R$22<=$J23)[/TD]
[/TR]
</tbody>[/TABLE]
Where R22 is the first date of my calendar which is going by weeks and I23 & J23 are dates.
EG. R22 is 1st jan and I23 & J23 are 1st April & 15th April. My formula highlights 1st - 15th April.
How do I get the cells between 1st-15th April only to also have a value which is in cell K23
EG. Cells turn Yellow and K23 is "5", so all cells in those dates also say 5.
I am really stuck, please help!
I am using Excel to create a calendar and I am using the formula to highlight all cells between date.
[TABLE="width: 141"]
<tbody>[TR]
[TD="width: 141"]=AND(R$22>=$I23,R$22<=$J23)[/TD]
[/TR]
</tbody>[/TABLE]
Where R22 is the first date of my calendar which is going by weeks and I23 & J23 are dates.
EG. R22 is 1st jan and I23 & J23 are 1st April & 15th April. My formula highlights 1st - 15th April.
How do I get the cells between 1st-15th April only to also have a value which is in cell K23
EG. Cells turn Yellow and K23 is "5", so all cells in those dates also say 5.
I am really stuck, please help!
