Discussion Conditional format in Excel
https://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2815353#M116815
<P> </P><P>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. </P><P> </P><TABLE width="567"><TBODY><TR><TD width="132">Appt Date</TD><TD width="54">account</TD><TD width="118">Client First Name</TD><TD width="116">Client Last Name</TD><TD width="147">Service</TD></TR><TR><TD>5/3/2021 12:30 PM</TD><TD>28458</TD><TD>Aaron</TD><TD>Banks</TD><TD>TELD3</TD></TR><TR><TD>5/3/2021 2:00 PM</TD><TD>28458</TD><TD>Aaron</TD><TD>Banks</TD><TD>TELD7</TD></TR><TR><TD>5/6/2021 12:00 PM</TD><TD>105065</TD><TD>Adiel</TD><TD>Jons</TD><TD>TELD7</TD></TR><TR><TD>5/14/2021 3:15 PM</TD><TD>105065</TD><TD>Adiel</TD><TD>Jons</TD><TD>TELD7</TD></TR><TR><TD>5/3/2021 1:45 PM</TD><TD>102937</TD><TD>Adrienne</TD><TD>white</TD><TD>TELD7</TD></TR><TR><TD>5/24/2021 11:45 AM</TD><TD>102937</TD><TD>Adrienne</TD><TD>white</TD><TD>TELD7</TD></TR><TR><TD>5/6/2021 2:00 PM</TD><TD>105024</TD><TD>Aleski</TD><TD>Brown</TD><TD>TELD7</TD></TR><TR><TD>5/10/2021 11:00 AM</TD><TD>105024</TD><TD>Aleski</TD><TD>Brown</TD><TD>TELD3</TD></TR><TR><TD>5/11/2021 11:00 PM</TD><TD>105024</TD><TD>Aleski</TD><TD>Brown</TD><TD>TELD3</TD></TR><TR><TD>5/13/2021 1:45 PM</TD><TD>105024</TD><TD>Aleski</TD><TD>Brown</TD><TD>TELD7</TD></TR><TR><TD>5/14/2021 8:00 AM</TD><TD>105024</TD><TD>Aleski</TD><TD>Brown</TD><TD>D3 - CD Group Session</TD></TR></TBODY></TABLE>Wed, 06 Oct 2021 00:03:23 GMTJulMir06892021-10-06T00:03:23ZConditional format
https://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2815353#M116815
<P> </P><P>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. </P><P> </P><TABLE width="567"><TBODY><TR><TD width="132">Appt Date</TD><TD width="54">account</TD><TD width="118">Client First Name</TD><TD width="116">Client Last Name</TD><TD width="147">Service</TD></TR><TR><TD>5/3/2021 12:30 PM</TD><TD>28458</TD><TD>Aaron</TD><TD>Banks</TD><TD>TELD3</TD></TR><TR><TD>5/3/2021 2:00 PM</TD><TD>28458</TD><TD>Aaron</TD><TD>Banks</TD><TD>TELD7</TD></TR><TR><TD>5/6/2021 12:00 PM</TD><TD>105065</TD><TD>Adiel</TD><TD>Jons</TD><TD>TELD7</TD></TR><TR><TD>5/14/2021 3:15 PM</TD><TD>105065</TD><TD>Adiel</TD><TD>Jons</TD><TD>TELD7</TD></TR><TR><TD>5/3/2021 1:45 PM</TD><TD>102937</TD><TD>Adrienne</TD><TD>white</TD><TD>TELD7</TD></TR><TR><TD>5/24/2021 11:45 AM</TD><TD>102937</TD><TD>Adrienne</TD><TD>white</TD><TD>TELD7</TD></TR><TR><TD>5/6/2021 2:00 PM</TD><TD>105024</TD><TD>Aleski</TD><TD>Brown</TD><TD>TELD7</TD></TR><TR><TD>5/10/2021 11:00 AM</TD><TD>105024</TD><TD>Aleski</TD><TD>Brown</TD><TD>TELD3</TD></TR><TR><TD>5/11/2021 11:00 PM</TD><TD>105024</TD><TD>Aleski</TD><TD>Brown</TD><TD>TELD3</TD></TR><TR><TD>5/13/2021 1:45 PM</TD><TD>105024</TD><TD>Aleski</TD><TD>Brown</TD><TD>TELD7</TD></TR><TR><TD>5/14/2021 8:00 AM</TD><TD>105024</TD><TD>Aleski</TD><TD>Brown</TD><TD>D3 - CD Group Session</TD></TR></TBODY></TABLE>Wed, 06 Oct 2021 00:03:23 GMThttps://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2815353#M116815JulMir06892021-10-06T00:03:23ZRe: Conditional format
https://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2815583#M116819
<P><LI-USER uid="1176281"></LI-USER> Hi there,</P><P>I made slight changes in your excel file, solved the issue and attached to this email.</P><P>I changed date to day format. Added two repetitive rows to be sure that the conditional formatting works well.</P><P>To solve this issue, I used Countifs and If functions.</P><P>Have a good day.</P><P>P.S.</P><P>=IF(COUNTIFS($A$2:$A$14,A2,$C$2:$C$14,C2)>1,TRUE, FALSE)</P><P> </P><P> </P><P>If you like this solution, please highlight:))</P>Wed, 06 Oct 2021 02:21:11 GMThttps://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2815583#M116819Ilgar_Zarbaliyev2021-10-06T02:21:11ZRe: Conditional format
https://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2815600#M116820
<P>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?<LI-USER uid="481821"></LI-USER> </P>Wed, 06 Oct 2021 02:35:35 GMThttps://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2815600#M116820JulMir06892021-10-06T02:35:35ZRe: Conditional format
https://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2815807#M116827
<P><LI-USER uid="1176281"></LI-USER> </P><P>Conditional Formatting is working on basis of Boolean Logic (True or False Values).<BR />Actually, if you take if function from my formula, it will give you numbers.<BR />=COUNTIFS($A$2:$A$14,A2,$C$2:$C$14,C2)</P>Wed, 06 Oct 2021 04:38:43 GMThttps://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2815807#M116827Ilgar_Zarbaliyev2021-10-06T04:38:43ZRe: Conditional format
https://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2959923#M122075
<P><LI-USER uid="481821"></LI-USER></P><P>I continue to have the hardest time figuring this out, can you help me again?</P><P>I need to find a way to conditional format the same person with multiple dates that are the same (cell 10,11 and 12) then count the duration (Column F 120 minutes) and place a #1 in AH and since its more than one service cell AK needs a 1 in it Aswell as a 1 in cells M because its a D22 AA because its a D7 and AB because its a D3</P><P>but this is definitely to complicated for me, i am not even sure if it is possible.</P><P>do you think you can help me?</P><P> </P><TABLE width="2926"><TBODY><TR><TD width="141">Appt Date</TD><TD width="66">account</TD><TD width="127">Patient First Name</TD><TD width="125">Patient Last Name</TD><TD width="266">Service</TD><TD width="62">Duration</TD><TD width="66">D15</TD><TD width="66">D11(45)</TD><TD width="66">D11(30)</TD><TD width="66">CDP</TD><TD width="110">smoking change</TD><TD width="66">injec</TD><TD width="66">D22</TD><TD width="66">D21</TD><TD width="66">D20</TD><TD width="66">D19</TD><TD width="66"> D 1</TD><TD width="66">D14</TD><TD width="66">D15</TD><TD width="115">15 min screening</TD><TD width="66">D6</TD><TD width="66">D16</TD><TD width="66">C15</TD><TD width="66">D18</TD><TD width="66">D8</TD><TD width="66">D2</TD><TD width="66">D7</TD><TD width="66">D3</TD><TD width="66">D10</TD><TD width="66">45 mins</TD><TD width="66">60 mins</TD><TD width="66">75 mins</TD><TD width="66">90 mins</TD><TD width="66">105 mins</TD><TD width="66">120 mins</TD><TD width="66">120+ mins</TD><TD width="66">2nd visit</TD></TR><TR><TD>10/1/2021 2:00 PM</TD><TD>28458</TD><TD>phil</TD><TD>Smith</TD><TD>TELD7</TD><TD>45</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/7/2021 11:45 AM</TD><TD>28458</TD><TD>phil</TD><TD>Smith</TD><TD>TELD7</TD><TD>45</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/29/2021 12:00 PM</TD><TD>28458</TD><TD>phil</TD><TD>Smith</TD><TD>TELD7</TD><TD>45</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/21/2021 9:00 AM</TD><TD>107862</TD><TD>mike</TD><TD>Lora</TD><TD>TELD1</TD><TD>75</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/22/2021 10:30 AM</TD><TD>107862</TD><TD>mike</TD><TD>Lora</TD><TD>TELD7</TD><TD>45</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/25/2021 9:00 AM</TD><TD>107862</TD><TD>mike</TD><TD>Lora</TD><TD>TELD22= Telehealth E&M 10-19 min</TD><TD>10</TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/25/2021 10:00 AM</TD><TD>107862</TD><TD>mike</TD><TD>Lora</TD><TD>TELD6</TD><TD>45</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/27/2021 9:00 AM</TD><TD>107862</TD><TD>mike</TD><TD>Lora</TD><TD>TELD7</TD><TD>45</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/29/2021 11:15 AM</TD><TD>107862</TD><TD>mike</TD><TD>Lora</TD><TD>D7 - Individual therapy - Norm 45</TD><TD>45</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/29/2021 1:15 PM</TD><TD>107862</TD><TD>mike</TD><TD>Lora</TD><TD>D22- Evaluation and Management 10-19</TD><TD>10</TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/29/2021 2:00 PM</TD><TD>107862</TD><TD>mike</TD><TD>Lora</TD><TD>D3 - CD Group Session</TD><TD>60</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/1/2021 3:00 PM</TD><TD>102937</TD><TD>joe</TD><TD>Reed</TD><TD>TELD7</TD><TD>45</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/25/2021 2:00 PM</TD><TD>102937</TD><TD>joe</TD><TD>Reed</TD><TD>TELD7</TD><TD>45</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/13/2021 4:00 PM</TD><TD>29362</TD><TD>bill</TD><TD>Ramos</TD><TD>TELD7</TD><TD>45</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/13/2021 6:00 PM</TD><TD>29362</TD><TD>bill</TD><TD>Ramos</TD><TD>TELD19</TD><TD>30</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>10/20/2021 10:00 AM</TD><TD>29362</TD><TD>bill</TD><TD>Ramos</TD><TD>D19 - CD Peer Support</TD><TD>30</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>Fri, 12 Nov 2021 19:52:59 GMThttps://techcommunity.microsoft.com/t5/excel/conditional-format/m-p/2959923#M122075JulMir06892021-11-12T19:52:59Z