Conditional formatting on cells dependent on other functional cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1780881%22%20slang%3D%22en-US%22%3EConditional%20formatting%20on%20cells%20dependent%20on%20other%20functional%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1780881%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20trying%20conditional%20formatting%20using%20formula%20to%20connect%20the%20inputs%20in%20one%20column%20of%20cells%20to%20the%20other%20column%20in%20an%20excel%20sheet%20but%20I%E2%80%99m%20not%20able%20to%20connect%20the%20two.%3CBR%20%2F%3ECan%20someone%20help%20me%20with%20finding%20the%20right%20syntax%20please%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1780881%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-1781040%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20on%20cells%20dependent%20on%20other%20functional%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1781040%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F817861%22%20target%3D%22_blank%22%3E%40waqasahmed85%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20were%20to%20place%20the%20formula%20in%20the%20top-left%20cell%20of%20the%20CF%20range%2C%20it%20should%20reference%20the%20cells%20you%20wish%20to%20test%20and%20return%20TRUE%2FFALSE.%26nbsp%3B%20Filling%20down%20or%20across%20would%20generate%20a%20pattern%20of%20TRUE%2FFALSE%20that%20corresponds%20to%20the%20pattern%20you%20expect%20to%20see.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20the%20formula%20from%20the%20top%20left%20cell%20to%20define%20the%20new%20conditional%20format.%26nbsp%3B%20Reinstate%20any%20formulas%2Fvalues%20in%20the%20CF%20range%20you%20may%20have%26nbsp%3B%20lost%20while%20developing%20the%20CF%20conditions..%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
I’m trying conditional formatting using formula to connect the inputs in one column of cells to the other column in an excel sheet but I’m not able to connect the two.
Can someone help me with finding the right syntax please
1 Reply
Highlighted

@waqasahmed85 

If you were to place the formula in the top-left cell of the CF range, it should reference the cells you wish to test and return TRUE/FALSE.  Filling down or across would generate a pattern of TRUE/FALSE that corresponds to the pattern you expect to see.

 

Use the formula from the top left cell to define the new conditional format.  Reinstate any formulas/values in the CF range you may have  lost while developing the CF conditions..