Forum Discussion
NJ1000
Mar 24, 2020Copper Contributor
Help in data validation formula: Cell cannot equal more than another
In my spreadsheet I need Cell A23 (which has it's value from cells A19:A22) to not be higher than the number already in cell H2 (which has it's value from cells B2:G2). I am using data validation...
- Mar 25, 2020
Without going down the route of VBA and change events, you could do this with conditional formatting which will not give a message but can allow a message which is not usually visible to be displayed under certain conditions i.e. if cell H23 > H2.........see attached file (I added the formula in H23 adding A19:A22 to demonstrate - to see how it works, change cell A20 from 1000 to zero).
Charla74
Mar 24, 2020Iron Contributor
In my spreadsheet I need Cell A23 (which has it's value from cells A19:A22) to not be higher than the number already in cell H2 (which has it's value from cells B2:G2).
Formula in cell A23 could be:
=IF(SUM(A19:A22)>H2,H2,SUM(A19:A22))