I would rather compare the month of the calendar data to the selected month, hence one conditional formatting would take care of the dates that don't belong to the current month.
@@ShedrackChukwuemeka-vl4dc =TEXT(B4,"mmmm")$B$2 Do not forget to check the "Applies to" in the conditional formatting dialog box, it should be for this instance : =$B$4:$H$9
tip: maybe explain how this would be more useful rather then using the default pc calendar. my reason is why invent something that is already working., so your first 30 sec, did not convince me, to continue watching your video. but I am being grateful to spend 5 min to leave a comment that will hopefully be as useful as the video tutorial itself. 😘
Interesting way to teach the use of these functions. Bravo!
Great video, clear, simple and beginner friendly. Thank you!
Nice explain
Legal, vc tem dois canais em Português e Inglês
My problem is removing that row at the bottom (including the left, right, and bottom borders). I mean the row from 4 to 10 in your example,
HOW DO I MAKE THE SMALL DATE LIKE 01 THRU 09 NOT HAVE THE ZERO IN FRONT OF IT?
I would rather compare the month of the calendar data to the selected month, hence one conditional formatting would take care of the dates that don't belong to the current month.
So how would you do it
@@ShedrackChukwuemeka-vl4dc
=TEXT(B4,"mmmm")$B$2
Do not forget to check the "Applies to" in the conditional formatting dialog box, it should be for this instance :
=$B$4:$H$9
tip: maybe explain how this would be more useful rather then using the default pc calendar. my reason is why invent something that is already working., so your first 30 sec, did not convince me, to continue watching your video. but I am being grateful to spend 5 min to leave a comment that will hopefully be as useful as the video tutorial itself. 😘