Forum Discussion
Conditional Formatting Question
I would like to find an easier way to "gray out" names in spreadsheets. I have a spreadsheet with columns of names, in a variety of different order on separate sheets based on different skills. I w...
Hi Ellis_C,
you can use the formula below in a Conditional Formatting rule. Please find example and file attached showing the solution.
=NOT(ISERROR(VLOOKUP(A2,$C$2:$C$20,1,0)))