Problem: Conditional formatting not working consistently for all cells defined.
Scenario: Need to cover a row with hash marks to blank it out when wrong part number is listed.
Row A37:F37 is covered by blue hashes if X is in A7 and C12 = TT60000678-
Part number in C12 is entered by formula when X is put in A7
To change part number in C12 requires an X in D22 or E22. Formula for this is in C12 .
=IF(AND(OR(D22="X",E22="X"),A7="X"), "TT60003571-",IF(AND(A7="X",(E4<=292)),"TT60000678-",IF(AND(A7="X",E4>=293,E4<=600),"TT60002639-",
IF(AND(A7="X",E4>=701,E4<=730),"TT60000678-",IF(AND(A7="X",E4>=601,E4<=604),"TT60000678-",IF(AND(A7="X",E4>=731),"TT60002639-", ""))))))
Conditional Formatting Formula for adding hash marks in A37:F37 works fine when X is put in E22.
It does not work when X is put in D22
Scenario: Need to cover a row with hash marks to blank it out when wrong part number is listed.
Row A37:F37 is covered by blue hashes if X is in A7 and C12 = TT60000678-
Part number in C12 is entered by formula when X is put in A7
To change part number in C12 requires an X in D22 or E22. Formula for this is in C12 .
=IF(AND(OR(D22="X",E22="X"),A7="X"), "TT60003571-",IF(AND(A7="X",(E4<=292)),"TT60000678-",IF(AND(A7="X",E4>=293,E4<=600),"TT60002639-",
IF(AND(A7="X",E4>=701,E4<=730),"TT60000678-",IF(AND(A7="X",E4>=601,E4<=604),"TT60000678-",IF(AND(A7="X",E4>=731),"TT60002639-", ""))))))
Conditional Formatting Formula for adding hash marks in A37:F37 works fine when X is put in E22.
It does not work when X is put in D22