Excel conditional formatting based on another changeable cell value

%3CLINGO-SUB%20id%3D%22lingo-sub-2277115%22%20slang%3D%22en-US%22%3EExcel%20conditional%20formatting%20based%20on%20another%20changeable%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2277115%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20i%20have%20been%20asked%20%2C%20how%20to%20setup%20conditional%20formatting%20based%20on%20another%20two%20cell%20value%20which%20are%20changeable.%20for%20more%20information%20please%20see%20the%20attachment%20sheet..%3CA%20title%3D%22Untitled%20spreadsheet%22%20href%3D%22https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F17-TeE7XfaYWYQofdO720Wlfwd8LoO8vDWLjZ96iZTMc%2Fedit%23gid%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F17-TeE7XfaYWYQofdO720Wlfwd8LoO8vDWLjZ96iZTMc%2Fedit%23gid%3D0%3C%2FA%3E%26nbsp%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20in%20advance%20for%20any%20help%2C%20advice%20or%20clarification%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi i have been asked , how to setup conditional formatting based on another two cell value which are changeable. for more information please see the attachment sheet..https://docs.google.com/spreadsheets/d/17-TeE7XfaYWYQofdO720Wlfwd8LoO8vDWLjZ96iZTMc/edit#gid=0  

 

Thanks in advance for any help, advice or clarification

0 Replies