multiple conditional formatting a column/sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1784729%22%20slang%3D%22en-US%22%3Emultiple%20conditional%20formatting%20a%20column%2Fsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1784729%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20several%20sheets%20with%20phone%20numbers%20that%20I%20need%20to%20have%20cross-referenced.%20For%20example%3A%3C%2FP%3E%3CP%3EI%20have%20sheets%20labeled%20NO%20SHOW%2C%20ONLINE%20REQUEST%2C%20SCHEDULED%2C%20and%20CALL%20LOG.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20have%20the%20phone%20numbers%20in%20my%20call%20log%20to%20change%20the%20text%20color%20if%20there%20are%20duplicates%20(on%20that%20sheet)%2C%20the%20phone%20number%20cell%20highlighted%20in%20one%20color%20if%20the%20number%20is%20on%20the%20no%20show%20list%2C%20another%20color%20if%20the%20number%20is%20on%20the%20online%20request%20sheet%2C%20and%20another%20color%20if%20the%20number%20is%20on%20the%20scheduled%20list.%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20lists%20are%20ongoing%20and%20new%20information%20will%20be%20added%20daily.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1784729%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-1786307%22%20slang%3D%22en-US%22%3ERe%3A%20multiple%20conditional%20formatting%20a%20column%2Fsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1786307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F833962%22%20target%3D%22_blank%22%3E%40jennifer945%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20need%20as%20many%20rules%20as%20colors%20you'd%20like%20to%20use%20for%20highlighting.%20Thus%204%20if%20I%20understood%20the%20logic%20correctly.%20To%20show%20duplicates%20in%20the%20first%20sheet%2C%20it's%20like%20%3DCOUNTIF(A%3AA%2CA1)%26gt%3B1%2C%20to%20show%20if%20the%20value%20is%20another%20sheet%20column%20like%20%3DCOUNTIF(Sheet!A%3AA%2CA1)%26gt%3B0%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have several sheets with phone numbers that I need to have cross-referenced. For example:

I have sheets labeled NO SHOW, ONLINE REQUEST, SCHEDULED, and CALL LOG. 

I need to have the phone numbers in my call log to change the text color if there are duplicates (on that sheet), the phone number cell highlighted in one color if the number is on the no show list, another color if the number is on the online request sheet, and another color if the number is on the scheduled list. 

My lists are ongoing and new information will be added daily.  

1 Reply
Highlighted

@jennifer945 

You need as many rules as colors you'd like to use for highlighting. Thus 4 if I understood the logic correctly. To show duplicates in the first sheet, it's like =COUNTIF(A:A,A1)>1, to show if the value is another sheet column like =COUNTIF(Sheet!A:A,A1)>0