Hi All.
Bare with me if this has been asked before.
I’ve got a spreadsheet that I created in Google Sheets that works fine, but I’d like to move it to Excel instead because of the painfully slow load speeds of Google Sheets.
Basically, I have a list of items in Column A. If any cells in Column A match, then the formatting would begin.
It would next look at 3 columns I-K and if there is a match in any of those columns, then a corresponding cell in Column C will turn red.
If no match, then it moves on to Columns L-N. Any matches, turns Column C red as above.
If no match again, then it goes to Column O. If there’s a match, turn Column C red as above. If no match this time, it turns Column C green to let me know it’s clear to use.
I know this is VERY confusing to try and understand. If anyone’s available to help, I will gladly show the test file for further help.
Thanks in advance.
