So if a cell in column AN = "STOP" then I want to find all cells in column B that equal the corresponding cell to column AN, which would be in column AJ, and format all cells in column B that equal the text in column AJ. I created a "UNIQUE" listing that adds up all entries for a workorder and figures out it's defect rate and if it goes above a certain percentage I want to go back to the original column with multiple entries and highlight it Red.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional formatting from multiple columns
- Thread starter Plbarney6
- Start date
Similar threads
- Question
