Forum Discussion

Copper Contributor

Mar 02, 2022

Solved

Conditional Formating Formula

I have two columns with numbers. If the number in B column is higher than the number in A column highlight the cell green If the number in B column is lower than the number in A column highlight...

Formulas and Functions

Martin_Weiss
Mar 02, 2022
Hi daniel315

you would need 3 rules for conditional formatting:
Yellow: =AND(B1>=A1*0,9;B1<=A1*1,1)
Red: =B1<A1
Green: =B1>A1

Depending on your regional settings it might be that you need to replace the first formula like this:
=AND(B1>=A1*0.9,B1<=A1*1.1)

Frank1060

Copper Contributor

Feb 15, 2024

Martin_Weiss I could use your expertise with an Excel conditional formatting issue. I want to highlight a row in blue if the value in cell L867 remains "Not contacted yet" for 40 minutes. The L column has a dropdown list, and I'm a bit stuck on the formula. Your assistance would be greatly appreciated.

Thanks a bunch!

Martin_Weiss

Bronze Contributor

Feb 19, 2024

Hi Frank1060

it's not completely clear to me, what the exact rules should be for your formatting. When you say: "not yet contacted" for 40 minutes:

40 minutes related to what exactly? To a certain record in the list? Which one?

I also propose to put your question in a complete new thread, so it gets more attention by other users.

Cheers,

Martin