maniniinfotech
Member
Hi to all am facing problem in conditional formatting ,i have attached the file and i have two if conditions ,one of the if condition is working and conditional formatting also working and second if condition is working but conditional formatting is not working
1st condition
=MOD(ABS(IF(LEFT(A1,1)>=LEFT(A14,1),(LEFT(A1,1)-LEFT(A14,1)-10),LEFT(A1,1)-LEFT(A14,1)))&(ABS(IF(RIGHT(A1,1)>=RIGHT(A14,1),(RIGHT(A1,1)-RIGHT(A14,1)-10),RIGHT(A1,1)-RIGHT(A14,1)))),100)=
2nd condition
=MOD((IF(LEFT(A47,1)>=RIGHT(A34,1),LEFT(A47,1)-RIGHT(A34,1),LEFT(A47,1)+10-RIGHT(A34,1))&(IF(RIGHT(A47,1)>=LEFT(A34,1),RIGHT(A47,1)-LEFT(A34,1),RIGHT(A47,1)+10-LEFT(A34,1)))),100)=
kindly go through the attachment in sheet 1 i have given examples and sheet 2 i have applied conditional formatting
1st condition
=MOD(ABS(IF(LEFT(A1,1)>=LEFT(A14,1),(LEFT(A1,1)-LEFT(A14,1)-10),LEFT(A1,1)-LEFT(A14,1)))&(ABS(IF(RIGHT(A1,1)>=RIGHT(A14,1),(RIGHT(A1,1)-RIGHT(A14,1)-10),RIGHT(A1,1)-RIGHT(A14,1)))),100)=
2nd condition
=MOD((IF(LEFT(A47,1)>=RIGHT(A34,1),LEFT(A47,1)-RIGHT(A34,1),LEFT(A47,1)+10-RIGHT(A34,1))&(IF(RIGHT(A47,1)>=LEFT(A34,1),RIGHT(A47,1)-LEFT(A34,1),RIGHT(A47,1)+10-LEFT(A34,1)))),100)=
kindly go through the attachment in sheet 1 i have given examples and sheet 2 i have applied conditional formatting