google-sheetsgs-conditional-formatting

How can i conditionally format a whole column


enter image description here

I want the right column to get a bold font whenever the left column is bigger.

For example: 0 should be bold and 59 should be bold in the right column.

Whenever I try it I add a range and then choose 'smaller than' and I choose the range of the left column it adds the complete column and compares it to the complete other column. I want them to be compared individually.


Solution

  • Go to

    And you're done.

    Go here for a live example, copy it to your own drive and have fun!