SOLVED

Problem with conditional formatting?

%3CLINGO-SUB%20id%3D%22lingo-sub-307564%22%20slang%3D%22en-US%22%3EProblem%20with%20conditional%20formatting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307564%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20write%20a%20formula%20for%20conditional%20formatting%20that%20compares%20cell%20A*10000%20with%20cell%20B%20and%20highlights%20one%20color%20if%20greater%20than%20and%20another%20if%20equal%20or%20less%20than.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-307564%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307639%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20conditional%20formatting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307639%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20taking%20the%20time%20to%20answer%20this%20question.%20For%20some%20reason%20I%20just%20wasn't%20getting%20it%2C%20but%20it%20works%20as%20intended%20so%20I%20appreciate%20your%20time%20on%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-307636%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20conditional%20formatting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-307636%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20mean%20compare%20the%20value%20of%20the%20each%20cell%20in%20column%20A%2C%20multiplied%20on%2010000%2C%20with%20the%20value%20in%20the%20adjacent%20cell%20in%20column%20B%20and%20colour%20cells%20in%20column%20A%2C%20when%20you%20may%20use%20two%20conditional%20formatting%20rules%20with%20formulas%3C%2FP%3E%0A%3CPRE%3E%3D%24A1*10000%26gt%3B%24B1%20%20%20%20%3D%26gt%3Bfirst%20rule%0A%0A%3D%24A1*10000%26lt%3B%3D%24B1%20%20%20%3D%26gt%3Bsecond%20rule%3C%2FPRE%3E%0A%3CP%3Eand%20apply%20them%20to%20%24A%3A%24A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted
Best Response confirmed by Keirgarth (New 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

 

Highlighted

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.