Data Validation and Conditional Formatting Question

0

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!

Post Edited
Title: Title was not descriptive.
Answer
Discuss

Answers

0
Selected Answer

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<A2

Now 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.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login