@cellmates_: Turning chaos into clarity one cell at a time. 😃 - Watch how custom + conditional formatting make deadline tracking effortless in Excel - your future self will thank you. - #excel #exceltips #exceltutorial #microsoftexcel #microsoft365
Good one. please how do you make it appear in number of months instead of days? Like 2 months left, 3 months overdue....
2026-05-02 19:14:17
2
JRTel30 :
You could do a part 2 where if you tick a box for completion it saves the date the box is ticked and put a line through the task. Awesome skills though 👏
2026-02-18 00:08:27
10
bsihan :
how about tracking workdays? and to exclude public holidays?
2026-02-17 19:54:39
9
Australia vibes :
You know you can use AI to do this 🙃
2026-02-18 13:39:21
5
DDK MAOR1 :
Awesome! I’m tired of using conditional formatting for colour coding purposes. Truly appreciate this👌
2026-02-19 08:33:44
1
iSmile Pictures 😊 :
This is nice. You just got a follower. Let's say, instead of the text changing color, you want the whole cell to change color in response to the number of days, how can you do that?
2026-02-23 05:25:22
5
Wayne Smyth :
can you set it to send an email reminder if it is coming up to its due date?
2026-02-17 21:39:05
7
Dquan :
let's say you need to make a report on the number of accounts opened by each branch, how can excel make it faster?
let's say each branch has a code number assigned to it
2026-04-26 01:25:38
1
Cichi :
please can u do a video on how to create graphs and maps
2026-03-05 06:50:05
2
Grant Saunders :
Excel didn’t let me use your code; it pointed me towards conditional formatting f
2026-02-23 18:03:18
1
Kelrobb78 :
can you build a dashboard that can track over multiple spreadsheets
2026-02-17 20:02:39
6
M :
welcome back to my fyp 🥰
2026-02-17 22:55:19
1
J Parky :
what if I just want it to count working days left?
2026-03-19 22:20:53
1
Aaron :
how does it know how many days over due is blue or red?
2026-02-19 18:53:32
1
fuzzysways :
Is there any way rather than due today to can do “due week commencing”
2026-02-25 07:35:13
1
Joe k :
can't download why
2026-03-20 07:51:34
0
Mustansar :
how color will be decided
2026-02-22 03:54:03
0
Kerr12 :
Great stuff. Thanks for the share!!
2026-02-21 23:25:57
2
Kawal :
I really like the way you explain ~simple English, + with a neat examples....Thank you.
2026-02-18 11:39:18
3
lifeonlowpower :
am so using this! thank you 🥰
2026-02-18 02:47:34
1
jkk_121 :
Class thank you 👏🏽
2026-02-18 01:53:37
1
Smart Jürgens :
Always tag me please
2026-02-18 14:54:46
0
luehrs45 :
Is there a way to use today() for weekdays only?
2026-02-19 03:36:41
1
Aaron :
perfect can this be used for quote updates for example sent quote follow up 7, 14& 30 days??
2026-02-17 19:59:00
2
Gary Hall :
Can you then sort that column into numerical order for days overdue > days remaining and expand the selection to ensure all rows are in order?
2026-02-18 00:51:30
1
To see more videos from user @cellmates_, please go to the Tikwm
homepage.