Again, watch the video but skip the part about the range and column. The intersection highlighting is described and does not depend on formatting the row or the column.
But perhaps you would like someone else to do everything for you?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post