I am hoping for a bit more help for the cross-matching phase in my veterinary research project.
I would like to highlight a cell if a cell in a different column in the same row is highlighted. For example, I would like A1 to be highlighted red if A2 is highlighted red, A1 to be highlighted blue if A2 is highlighted blue, and A1 to be highlighted yellow if A2 is highlighted yellow.
A2 contains its own formulas and its own conditioning formatting, and I want to put different text into A1, so I don’t want to do a direct copy and paste. Is this possible?
Thanks again,
Lauren.
I have not been able to find a way to do this on my own.