Good morning community,
I am still somewhat new to the community and excel using conditional formatting. I am currently using conditional formatting to highlight cells in a column for dates (ex. I input the date 1-Jan-2019 (cell turns red), 28-Aug-20 (cell turns yellow), 1-Jan-2021 (cell turns green). I have this down as it can be seen in the attachment.
However I would like to highlight the persons name (2 cells, Last name, First name) when any cells in that row. So if the entire row of conditional formatting is green, the Both A2 and B2 will show green, and if any of the cells in the row turn yellow or red it will automatically highlight the name in A2 and B2 to show that corresponding color, (if it shows red and yellow, red should go to the top).
I hope this is understandable and I hope someone is able to help me with the problem. Thank you and have a wonderful day!
- GulonRaid
Bookmarks