Excel conditional formatting does not work!

[David77]

Please help,

Super simply:

I have stock on column G and minimum stock on column F. I want to highlight my stock if it is below the minimum stock through conditional formatting:

As you can see, I have made the correct conditional formatting that if my value is equal to or less than F2 (scaling down to F3 for G3, F4 for G4, F5 for G5 etc.) then it should be highlighted in red.

However it just simply highlights everything which is very frustrating for me!

How do I fix this? Please help me! Thanks

 

[Fluff]

Rather than using Cell value, use a formula & use
=G2<=F2

 

[David77]

Rather than using Cell value, use a formula & use
=G2<=F2

Fluff you're amazing!

Thank you so much, it worked

Have a great weekend!

 

[sandy666]

no quotes

 

[Fluff]

You're welcome & thanks for the feedback

 

[David77]

View attachment 21667
no quotes

View attachment 21668

Yeah I think it's just my Excel that's being weird haha

 

[sandy666]

s

Yeah I think it's just my Excel that's being weird haha

sure