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...
Ellis_CTo use the formula, from the Conditional Formatting window click "New Rule" > "Use a formula to determine which cells to format".
As you mentioned, you want all the different sheets combined together and then a master column created like in my mini example. Easiest way to combine all sheets is with Power Query. With this approach you could even keep them in separate sheets and press Refresh to combine them into one.