• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting issue

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
 

Attachments

Top