I am sure there must be a simple way to do this but I cannot find the solution by searching the web. I am looking at patients with burns. Each row represents a unique patient. The diagnostic code for the size of burn occurs on one of four columns in the worksheet. I have used conditional formatting to highlight the appropriate cell in each row. Now I want to combine those four columns into one column that only shows the highlighted cells. The screen shot shows the "pattern". Any help gratefully received.
Last edited by a moderator: