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.)
(Please reply any solution here for the public to see and for your Best Response credit.)