Forum Discussion
Color-formatting a cell based on list of values across multiple columns
Got a complex one that has stumped my ability to Google. I've got a list of zip codes, subdivided into regions, and each region has a color. I want to put an address into a conditionally-formatted ce...
Patrick2788 that helped a lot, thank you. I was unable to get the formula to work by typing in the name of the column, but I'm also using Google Sheets rather than actual Excel, does that make a difference? I was able to make it work with =XMATCH(C2,B25:B75,0,1)
It might make a difference. I'm not at familiar with Sheets so I can't advise in that area.