Hi,
I have a list of part numbers down column C and the associated part descriptions down column D.
I have conditional formatting set up for column C so that if the part number contains “KEY”, the cell is highlighted.
I want the matching descriptions in column D to be highlighted as well but don’t know how to set up the conditional formatting to do this based on the value of another cell.
How would I set the conditional formatting to do this?
Thanks very much
Dave
Bookmarks