Hey Everyone,
I have another conditional formating challenge. I'm trying to get it so that every second cell from W4, turns white if C4 (and every second cell after that, C6, C8, etc) equal/match something in the name range "P.Ten" To solve the "Every Second Cell" i've been using =AND(MOD(ROW(),2)=0,_________ )) But I just dont know what to use to search in a name range. See Attached Sample.
sample.xlsm
Bookmarks