Forum Discussion
Conditional format
Having the hardest times setting up a conditional format were i need to highlight a duplicated date with the client first name. for instance Aaron had two services the same day 5/3/21 but when i do a conditional format Adrienne is highlighted as well but she does not have a duplicate service for the same day. i need to find a way to highlight clients that receive multiple services on the same day.
| Appt Date | account | Client First Name | Client Last Name | Service |
| 5/3/2021 12:30 PM | 28458 | Aaron | Banks | TELD3 |
| 5/3/2021 2:00 PM | 28458 | Aaron | Banks | TELD7 |
| 5/6/2021 12:00 PM | 105065 | Adiel | Jons | TELD7 |
| 5/14/2021 3:15 PM | 105065 | Adiel | Jons | TELD7 |
| 5/3/2021 1:45 PM | 102937 | Adrienne | white | TELD7 |
| 5/24/2021 11:45 AM | 102937 | Adrienne | white | TELD7 |
| 5/6/2021 2:00 PM | 105024 | Aleski | Brown | TELD7 |
| 5/10/2021 11:00 AM | 105024 | Aleski | Brown | TELD3 |
| 5/11/2021 11:00 PM | 105024 | Aleski | Brown | TELD3 |
| 5/13/2021 1:45 PM | 105024 | Aleski | Brown | TELD7 |
| 5/14/2021 8:00 AM | 105024 | Aleski | Brown | D3 - CD Group Session |
i like it but it would be helpful if it would be possible to have a number rather than true or false for instance if there are two services for the one day have a number 2 and if three services in the same day a number 3 is that possible?Ilgar_Zarbaliyev
4 Replies
JulMir0689 Hi there,
I made slight changes in your excel file, solved the issue and attached to this email.
I changed date to day format. Added two repetitive rows to be sure that the conditional formatting works well.
To solve this issue, I used Countifs and If functions.
Have a good day.
P.S.
=IF(COUNTIFS($A$2:$A$14,A2,$C$2:$C$14,C2)>1,TRUE, FALSE)
If you like this solution, please highlight:))
i like it but it would be helpful if it would be possible to have a number rather than true or false for instance if there are two services for the one day have a number 2 and if three services in the same day a number 3 is that possible?Ilgar_Zarbaliyev
Conditional Formatting is working on basis of Boolean Logic (True or False Values).
Actually, if you take if function from my formula, it will give you numbers.
=COUNTIFS($A$2:$A$14,A2,$C$2:$C$14,C2)
