Excel conditional formatting does not work!

D

David77

Board Regular
Joined
Jun 24, 2020
Messages
109
Office Version
  1. 365
Platform
  1. Windows
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:

1599228078807.png


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 :)
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
Rather than using Cell value, use a formula & use
=G2<=F2
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Conditional Formatting highlight cell in range based on a separate range
Replies
6
Views
612
felixstraube
F
V
  • Solved
Conditional Formatting Formula
Replies
2
Views
1K
awoohaw
awoohaw
A
  • Question Question
Conditional formatting icon sets for expiry 12months from date in cell
Replies
6
Views
406
MARK858
MARK858
J
  • Question Question
Conditional Formatting.. The bane of my Excel Existence
Replies
2
Views
861
RoryA
RoryA
T
  • Solved
Dates and conditional formatting
Replies
6
Views
770
kevin9999
K

Forum statistics

Threads
1,224,816
Messages
6,181,139
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top