I am trying to make a formula that changes the color of a cell, depending on how it compares to another...
For example I have a cell (A2), I want to compare its value to another cell (B2). If B2 is greater than A2, I want to change the color of A2's cell.
I already know how to change the color of a cell based on its comparison to a specific number, but I cannot figure out how to change it based on the value of another cell.
For example I have a cell (A2), I want to compare its value to another cell (B2). If B2 is greater than A2, I want to change the color of A2's cell.
I already know how to change the color of a cell based on its comparison to a specific number, but I cannot figure out how to change it based on the value of another cell.