SOLVED

Problem with conditional formatting?

Copper Contributor

I need to write a formula for conditional formatting that compares cell A*10000 with cell B and highlights one color if greater than and another if equal or less than.

 

Thank you in advance.

2 Replies
best response confirmed by Keirgarth (Copper Contributor)
Solution

If you mean compare the value of the each cell in column A, multiplied on 10000, with the value in the adjacent cell in column B and colour cells in column A, when you may use two conditional formatting rules with formulas

=$A1*10000>$B1    =>first rule

=$A1*10000<=$B1   =>second rule

and apply them to $A:$A

 

Thank you for taking the time to answer this question. For some reason I just wasn't getting it, but it works as intended so I appreciate your time on this.

1 best response

Accepted Solutions
best response confirmed by Keirgarth (Copper Contributor)
Solution

If you mean compare the value of the each cell in column A, multiplied on 10000, with the value in the adjacent cell in column B and colour cells in column A, when you may use two conditional formatting rules with formulas

=$A1*10000>$B1    =>first rule

=$A1*10000<=$B1   =>second rule

and apply them to $A:$A

 

View solution in original post