Many of us already understand the fundamentals of conditional formatting - highlighting cells that meet certain criteria, but what if you wanted to draw even more attention to the entire row of data. Maybe you have a large spreadsheet and some alert field is at the far end of your data set, and you don't want to keep scrolling to see whether a condition is met. Sometimes, it's helpful to highlight the entire row with conditional formatting.
The trick here is to create your condition and set your anchor so it stays in the target column, but the 1 but without the anchor so the row can freely move; =$B1="Awesome", but then apply the condition to more than one column.
I occasionally run into the situation where after creating the condition, I have to go back into the Rule and reset the row to 1. This target sometimes jumps to the bottom of the workbook when you first create the rule.
This is probably easier to follow in a video, so enjoy!