• 412K Members
• 3,974 Online
• 468K Conversations
SOLVED

New Contributor

# Problem with conditional formatting?

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.

2 Replies
Solution

# Re: Problem with conditional formatting?

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

# Re: Problem with conditional formatting?

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