Notifications
Clear all
Topic starter
Hello everyone,
I have made a list and used a drop down list to select names from that list. I need to grey out the names from the master list when I select them from the drop down list. Ex. when i select name in F2 it will grey out the name in I6. Attached is document
Posted : 22/03/2023 11:14 am
You can use the following conditional formatting formula for that.
=MATCH(I2,$F$2:$F$5,0) and apply it to $I$2:$I$6
Posted : 23/03/2023 12:36 am
Topic starter
Thank you Riny!
Posted : 24/03/2023 7:25 am
