Forum Discussion
How do I conditional format a column if certain value is present in a different column
Hey, I have a table with my Football Scouts and based on their knowledge they are fit to perform assignments. The assignments are represented as numbers between 1 and 30 and each represent their own...
I solved it with ChatGPT (I am sorry, I should have tried that before posting). Very interesting solution the AI suggested:
=ISNUMBER(MATCH(COLUMN(),$AJ$2:$AJ$34,0))
Worked for me.
Best