SOLVED
Home

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
Keirgarth
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
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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies