Forum Discussion
Need Help - Conditional Formatting based on another criteria range (column's last cell with data)
Greetings everyone, I have a decision matrix tool that dynamically expands columns/headings based on another sheet's (Pros vs. Cons) entries. I do not understand why the Conditional Formatting I ...
- Is it possible for you to post the actual spreadsheet (or an anonymous facsimile) on OneDrive or GoogleDrive, posting a link granting access to it here? That would help greatly in deciphering what you're seeking help on.
- Your formulas make reference to "ADDRESS" but you don't explain what that is (and it appears to be a significant part of the picture)
- You refer to row 3 and call it "Rankings" yet there doesn't appear to be any correlation between that description at the third row of the spreadsheet depicted in the image
So I think some clearer explanations of what we're looking at, what is desired, and access to the actual spreadsheet would help us help you,.
- Pardon me. I added a picture that shows the Excel reference headers. I hope that encompassed your questions 2 & 3. For question 1, please see the private message.
(Please reply any solution here for the public to see and for your Best Response credit.)
