SOLVED

Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-3347111%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3347111%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22%22%3EHi%2C%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EI%20need%20help%20with%20conditional%20formatting%20of%20two%20sheets.%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EUsing%20Example%202%20sheet%20-%20find%20the%20order%20%23(column%20A)%20and%20order%20total%20(column%20J)%20on%20Example%201%20sheet%20-%20%3CSTRONG%3Eif%20its%20a%20match%20color%20both%20lines%20GREEN%20on%20both%20sheets%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3EUsing%20Example%202%20sheet%20find%20the%20order%20%23%20and%20order%20total%20on%20Example%201%20sheet%20-%20i%3CSTRONG%3Ef%20the%20order%20%23%20is%20the%20same%20and%20order%20total%20is%20different%20color%20both%20lines%20YELLOW%20on%20both%20sheets%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3EUsing%20Example%202%20sheet%20find%20the%20order%20%23%20and%20order%20total%20on%20Example%201%20sheet%20-%20%3CSTRONG%3Eif%20neither%20is%20there%20color%20both%20line%20RED%20on%20both%20sheets%3C%2FSTRONG%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EI%20have%20attached%20the%20excel%20spreadsheet%20for%20reference.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3EThanks!%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sammie516_0-1652130065829.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370333i793485A9C4A43819%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sammie516_0-1652130065829.png%22%20alt%3D%22Sammie516_0-1652130065829.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sammie516_1-1652130088851.jpeg%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F370334iDC2E67BD841F7EEC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Sammie516_1-1652130088851.jpeg%22%20alt%3D%22Sammie516_1-1652130088851.jpeg%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3347111%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3347254%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3347254%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381885%22%20target%3D%22_blank%22%3E%40Sammie516%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20try%20the%20attached%20file.%20Maybe%20this%20is%20what%20you%20are%20looking%20for.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3347470%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3347470%22%20slang%3D%22en-US%22%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
Hi,
 
I need help with conditional formatting of two sheets. 
 
Using Example 2 sheet - find the order #(column A) and order total (column J) on Example 1 sheet - if its a match color both lines GREEN on both sheets
 
Using Example 2 sheet find the order # and order total on Example 1 sheet - if the order # is the same and order total is different color both lines YELLOW on both sheets
 
Using Example 2 sheet find the order # and order total on Example 1 sheet - if neither is there color both line RED on both sheets
 
I have attached the excel spreadsheet for reference.

Thanks!
 
Sammie516_0-1652130065829.png

 

Sammie516_1-1652130088851.jpeg

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Sammie516 

You can try the attached file. Maybe this is what you are looking for.

Thanks!