I have two columns Marks and Expected Marks, using conditional formatting i want to highlight all cells where marks are greater than expected marks in the same row. How to apply such conditional formatting over multiple rows.
CodePudding user response：
Select marks cells, in conditional formatting choose "Format only cells that contains", then choose "Greater than" and choose first cell from expected marks column.
Result:
