Hi All.
I have 2 questions that I can not figure out RE Conditional Formatting
*** I have attached an example spreadsheet with what I believe to be fairly detailed explanations and examples of what I am trying to accomplish and the issues I need to solve. Please let me know if this is enough info or not. I will summarize here as well:
1) Confirming the exact formula that is to be input in order to conditionally FORMAT MULTIPLE CELLS BASED ON THE VALUE OF ONLY 1 OF THEM
2) Find a way to simplify copying this Multiple outcome (3) Conditional Format to ALL other cell(s) , but have them copied to that cell as RELATIVE to itself, rather than just copying the conditional formatting of the original that was copied...Hope that makes sense. More details in the Attachment.
*Side Note: If there is a way to solve #2, the only kicker is that I cannot use VBA as per my companies compliance restrictions...Hopefully there is a way to do this without it haha.
Please let me know if possible, and as always - Thank you very much for the help in advance!
Bookmarks