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)+10RIGHT(A34,1))&(IF(RIGHT(A47,1)>=LEFT(A34,1),RIGHT(A47,1)LEFT(A34,1),RIGHT(A47,1)+10LEFT(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)+10RIGHT(A34,1))&(IF(RIGHT(A47,1)>=LEFT(A34,1),RIGHT(A47,1)LEFT(A34,1),RIGHT(A47,1)+10LEFT(A34,1)))),100)=
kindly go through the attachment in sheet 1 i have given examples and sheet 2 i have applied conditional formatting
Attachments

29 KB Views: 9