Ravi Sir's Cards › Excel
Highlight a whole row with a formula rule
Revision card: Highlight a whole row with a formula rule. Example data table with What to select: A2:G4; Rule: colour rows where Result is Fail: row 3 coloured; Why $F2 and not $F$2?: row moves, column fixed.
Read card text
What this card says
Highlight a whole row with a formula rule
Example
data table with What to select: A2:G4; Rule: colour rows where Result is Fail: row 3 coloured; Why $F2 and not $F$2?: row moves, column fixed
Learn this in the lesson: How to Highlight an Entire Row in Excel with Conditional Formatting (Formula Rule)