Aug 02 2022 10:14 AM
Hello all,
I've tried using the formula below within conditional formatting, but it returns "There's a problem with this formula" (If screenshots would help, I can provide those).
=COUNTIFS(Attendance_Tracker[Employee Name],Employee_Name,Attendance_Tracker[Start Date],"<="&B7,Attendance_Tracker[End Date],">="&B7,Attendance_Tracker[Absence Type],'Attendance & Tardiness Codes'!$A$3)>0
Normally I would just assume I typed something wrong, but the formula works outside of the conditional formatting rules. I'm a little confused on what I might be missing. Any help would be greatly appreciated.
Aug 02 2022 11:40 AM
SolutionConditional Formatting does not accept structured table references in a formula. You'll have to use the corresponding cell addresses.
Aug 03 2022 11:43 AM
Dec 12 2022 11:11 PM
Aug 02 2022 11:40 AM
SolutionConditional Formatting does not accept structured table references in a formula. You'll have to use the corresponding cell addresses.