HELP with table ideas

[Abed_tt]

Hello forum, i wanted a way in which i can be present such data in a professional way . i dont know whether charts or if there is anything else i can use to better present it. i would like a few recommendation please. I was also wondering if there is something i could use as a count down to the due date date.

DTCB MASTER SPREADSHEET UPDATED J021.xlsx
	A	B	C			F	G	H
1	DATE	EMPLOYEE	ID NUMBER			POSITION	NEXT DUE DATE	STATUS
2	2021/02/19	CECILY KUSWANE	797825308			COOPERATE AFFAIRS MANAGER	19 February 2022	VALID
6	2020/12/18	JANE SANTAGANE	510229500			EXECUTIVE ASSISTANT	18 December 2022	VALID
7	2019/06/28	PILELE KENOSI	656926406			EXECUTIVE ASSISTANT	28 June 2020	OVERDUE FOR MEDICALS
8	2019/11/13	LETSHABO KAGO	902723410			COMPANY SECRETARY	13 November 2020	OVERDUE FOR MEDICALS
9	2020/12/16	TEBOGO SELEKA	112223315			CORPORATE COMMUNICATION SPECIALIST	14 December 2021	VALID
10	2018/11/10	PAPHANE BOTLHALE	526418608			SENIOR INTERNAL AUDITOR	10 November 2019	OVERDUE FOR MEDICALS
MDs OFFICE

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C10	Cell Value	duplicates	text	NO
B10	Cell Value	duplicates	text	NO
C10	Cell Value	duplicates	text	NO
B9	Cell Value	duplicates	text	NO
C9	Cell Value	duplicates	text	NO
C8	Cell Value	duplicates	text	NO
B8	Cell Value	duplicates	text	NO
C8	Cell Value	duplicates	text	NO
B6:B7	Cell Value	duplicates	text	NO
C6:C7	Cell Value	duplicates	text	NO
C2	Cell Value	duplicates	text	NO
B1:B3	Cell Value	duplicates	text	NO
C1:C3	Cell Value	duplicates	text	NO

 

[etaf]

I was also wondering if there is something i could use as a count down to the due date date.

you could use a Red/Amber/Green RAG conditional formatting to highlight the rows
Using today() to get todays date and then you can show maybe
RED = overdue
Amber = Due in next X days
Green = Due later than the X days

OR a Number of days till due again using Today() to get todays date

Whats the purpose of the presentation, what are you trying to show ?

 

[Abed_tt]

you could use a Red/Amber/Green RAG conditional formatting to highlight the rows
Using today() to get todays date and then you can show maybe
RED = overdue
Amber = Due in next X days
Green = Due later than the X days

OR a Number of days till due again using Today() to get todays date

Whats the purpose of the presentation, what are you trying to show ?

Its a monthly report we send to make its easy for HR to book clients next medicals.

 

[Abed_tt]

ok i think this will do for now ill hear from them if i need do more

DTCB MASTER SPREADSHEET UPDATED J021.xlsx
	B	C			F		H	I		K	L	M	N
1	EMPLOYEE	ID NUMBER			DEPARTMENT		NEXT DUE DATE	STATUS
2	KAGO MMOPI	282715206			MANAGING DIRECTOR		14 December 2019	OVERDUE FOR MEDICALS			HIGHLIGHT CONDITIONS
3	PAPHANE BOTLHALE	526418608			MANAGING DIRECTOR		15 December 2019	OVERDUE FOR MEDICALS
4	LETSHABO KAGO	902723410			MANAGING DIRECTOR		13 November 2020	OVERDUE FOR MEDICALS			OVERDUE		LIKE THIS
5	TEBOGO SELEKA	112223315			MANAGING DIRECTOR		14 December 2021	VALID
6	CECILY KUSWANE	797825308			MANAGING DIRECTOR		19 February 2022	VALID			OVERDUE SOON (NEXT 30 DAYS)		LIKE THIS
7	MAJE TINY	‭031922803‬			MANAGING DIRECTOR		N/A	DUE FOR BOOKING
8	SERUMOLA SEDIRENG	‭857814004‬			MANAGING DIRECTOR		N/A	DUE FOR BOOKING
MDs OFFICE

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H1:H8	Cell Value	between TODAY() and TODAY()+30	text	NO
H1:H8	Cell Value	<44212	text	NO
C5:C7	Cell Value	duplicates	text	NO
C4	Cell Value	duplicates	text	NO
C1:C8	Cell Value	duplicates	text	NO
C1:C8	Cell Value	duplicates	text	NO
B1:C8	Cell Value	duplicates	text	NO
B1:B8	Cell Value	duplicates	text	NO
B1:B8	Cell Value	duplicates	text	NO
B1:B8	Cell Value	duplicates	text	NO
C1:C8	Cell Value	duplicates	text	NO
B1:B8	Cell Value	duplicates	text	NO
C1:C8	Cell Value	duplicates	text	NO