I would like to know if there is a way to conditionally format a column. I want cells in column C to highlight if they are higher than the values in Column B. However, the values in column B differ in each row. Is there a way to condition one cell in column C and drag it down so I don't have to condition each cell?
Select column C, goto conditional formatting and choose new rule.
Select the second option: Format only cell that contain.
1st dropdown: Cell value
2nd dropdown: Greater then
3rd field: B1
Choose format
Click OK