Conditional Formatting in Excel

By billc46 ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums