SOLVED

# Conditional Formatting Formula Error

Occasional Contributor

# Conditional Formatting Formula Error

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.

2 Replies
best response confirmed by Corder (Occasional Contributor)
Solution

# Re: Conditional Formatting Formula Error

Conditional Formatting does not accept structured table references in a formula. You'll have to use the corresponding cell addresses.

# Re: Conditional Formatting Formula Error

Thank you! I found that if you name the cells, you can use that name as a reference.