Cell A1 = £10,000
The usual way to calculate this would be:
=SUM(A2:A4)
E.G.
A2 = £5,000
A3 = £2,500
A4 = £2,500
However, I want my colleagues to enter the numbers without automating the formula "=SUM(A2:A4)".
However, I don't want to autosum cell A1, but I want to create or use a formula that will highlight that cell A1 doesn't equal A2:A4.
Any advice on how to do this?
Welcome to the board
Something like:
Formula:
Please Login or Register to view this content.
in another cell
Or would you prefer cell A1 itself to be highlighted?
Last edited by kev_; 03-20-2017 at 07:21 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
You can add a conditional formatting rule for A1 that says
=A1<>SUM(A2:A4)
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
To highlight the cell after this is registered...Originally Posted by kev_
Welcome to the board
Something like:
Formula:Please Login or Register to view this content.
in another cell
Or would you prefer cell A1 itself to be highlighted?
Did you see 6String';s suggestion above?
If you are unfamiliar with Conditional Formatting...
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A1<>SUM(A2:A4) Format Fill as needed
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
My earlier post as a conditional format is illustrated in attached workbook
conditformat102.jpg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks