I have a column of numbers (column A) which I'd like to compare to an adjacent column of numbers (column B) and, by row, determine if the number is larger. If it is, I'd like to place a different colour on the cell. What is the formula I need to use to accomplish this?
Ex:
Col A Col B
30,000 5,000 - A is larger than B, therefore A is formatted RED
20,000 20,000 - A is the same as B, therefore no format applied
10,000 15,000 - A is less than B, therefore A is formatted GREEN
Thank you!
Bookmarks