Notifications
Clear all
General Excel Questions & Answers
5
Posts
3
Users
0
Reactions
61
Views
Topic starter
Hi Mynda
I am trying to highlight cells with certain names. I have created a named range - lookup2 , and tried to use this in the formula , but it did not work. Are you able to assist ? See attached file
Christine
Posted : 16/04/2023 11:37 pm
Try this formula as the rule for conditional formatting.
=ISNUMBER(MATCH(B2,lookup2,0))
I believe it does what you need.
Posted : 17/04/2023 12:17 am
Topic starter
Hi Riny, don't worry i worked it out.
Posted : 17/04/2023 2:27 am
The formula should be entered WITHOUT the quotes like the COUNTIF you had, just replace that formula with Riny's formula and it works.
Posted : 17/04/2023 2:57 am
Have you solved it?
Posted : 25/04/2023 1:53 am
