S s2310 New Member Aug 5, 2023 #1 Hello, I want to highlight numbers in a array that are contained in a list. See attached excel for example. Thanks, Attachments conditional format.xlsx 9 KB · Views: 6
Hello, I want to highlight numbers in a array that are contained in a list. See attached excel for example. Thanks,
ETAF Active Member Aug 5, 2023 #2 try =COUNTIF($J$5:$J$8,D5)>0 as a conditional formatting rule Attachments conditional format-ETAF.xlsx 9.1 KB · Views: 5
S s2310 New Member Aug 5, 2023 #4 ETAF said: try =COUNTIF($J$5:$J$8,D5)>0 as a conditional formatting rule Click to expand... Wow.. Thankyou.. Works like a charm. Much much appreciated sir.
ETAF said: try =COUNTIF($J$5:$J$8,D5)>0 as a conditional formatting rule Click to expand... Wow.. Thankyou.. Works like a charm. Much much appreciated sir.
