I'm am trying to turn cells that meet specific criteria in a single column a color.
I am able to do this if I want one specific thing colored, but I'm trying to, again, do it to multiple criteria.
Imagine if you will Column I has infinite rows, each cell in Column I has a five digit number ie. 12345, 12346, 12347, 12348, etc. These numbers duplicate frequently. I want to high light the cells that read 12345, 12347, 12349 in column I the color red.
How can I do this... I've tried all of my limited knowledge.
I am able to do this if I want one specific thing colored, but I'm trying to, again, do it to multiple criteria.
Imagine if you will Column I has infinite rows, each cell in Column I has a five digit number ie. 12345, 12346, 12347, 12348, etc. These numbers duplicate frequently. I want to high light the cells that read 12345, 12347, 12349 in column I the color red.
How can I do this... I've tried all of my limited knowledge.