Complicated Conditional Formatting?

Copper Contributor

Hi Everyone,

 

I was wondering if I can get some help with an issue I'm having. I have a column with a numerical value and a Yes/No column. If the numerical value is 3 or greater and a No is entered into the column, I would like it to change colors. I'm having difficulties with the formula.  Can someone please help?

3 Replies

@nicolelpasden 

Please see here and attached

image.png

@SergeiBaklan 

 

It didn't work.

nicolelpasden_0-1721378484599.png

 

@nicolelpasden 

It works.

G2>3  - false

G3>3  - false

 

You have no one cell in column G, at least on screenshot, which is greater than 3. Thus nothing to highlight.