200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I am trying to set up an If then formula to have one catagory of information to NEVER EXCEED another category.
I have spending and it cannot be more than commitments.
Also, I want it to highlight red if the amount does exceed, so we know to go back and fix it.
Thank you!
Select the cell to limit and hit Alt + D + L and then under the settings tab go to Allow and select Custom and input this formula:
=A1<A2Now you can't enter a value in cell A1 that is higher than cell A2.
If you want to highlight the cell use conditional formatting. Select the cell > go to Home tab > Conditional Formatting > Highlight Cells Rules > Greater Than > for the input on the left of the new window, delete its contents and, while the cursor is still blinking within the input area, select the cell that this cell should not be higher than and click OK.