excel for mac if one column is greater than another

The IF function returns TRUE if the condition is met and FALSE if otherwise.

If you want to save hours of research and frustration, try our live Excelchat service Our Excel Experts are available 247 to answer any Excel question you may have.

We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

If any cell in the selected range will contain a number greater than or equal to the number you have entered, they will be highlighted.

Note: in this example if any cell in the selected range contain a number greater than or equal to 500 they will be highlighted.

You can also change the name of this object variable, by changing the name ws in the VBA code.

Highlight Range: Select the range in which to highlight cells that contain a number greater than or equal to a specific number by changing the range (B3:B9) in the VBA code.

Highlight Color: Select the color to highlight cells that contain a number greater than or equal to a specific number in the selected range by changing the RGB code (220, 230, 241) in the VBA code.

Specific Number: Select the number that you want to highlight if a cells contains a number that is greater than or equal to this number, by changing the number of 500 in the VBA code.

Excel For Mac If One Column Is Greater Than Another