How do you format inbetween Dates in Excel?
Hi, I need to format an Excel Document for a school project so it shows when what needs to be done. Unfortunately, my Teacher is not able to help me, and my Excel skills aren't exactly the best (I'm still learning).
Basically, what I need to do is find a way to make the blank parts turn a different colour when they match a date between the ones given in column D or E in the right row (e.g. in row 2 it needs to match the dates between D2 and E2, in row 9 it needs to match the dates between D9 and E9, etc)
Is there any way I can do this? Unfortunately, I cannot find any tutorials on this topic, so if someone could explain it that'd be amazing (a link to an existing tutorial would be fine as well, I just couldn't find one)
Edit: I've tried to format it by using Conditional formatting and I'm sure I can solve it by using that, but i've tried using it and it didn't work (I probably used the wrong one? I'm not sure I wanted to use the Date formatting option but it only showed I could use dates like "today" or "in two weeks" which is not what I need. Then again, if I use the in between with standard numbers, it won't work either because maybe cannot read it due to it being dates?)
Any help would be appreciated :>
I'm using Version 2601 of Excel!
[link] [comments]
Want to read more?
Check out the full article on the original site