Nov 24, 2020

checkbox autocheck once value of another cell reaches a certain threshold

I have a cell that holds a checkbox. I'd like the checkbox to automatically check once the value of another cell reaches a certain threshold. 
For example:
cell F36 has a value of $224,999 checkbox is in cell G36. Once F36 keeps climbing to $225,000 and up based on the formula in it, I'd like to have the checkbox in G36 checked
How do I do this?
Locked
Informational notification.
This question is locked and replying has been disabled.
Community content may not be verified or up-to-date. Learn more.
Recommended Answer
Nov 25, 2020
Hi Brandon,

For this single cell this could be a simple as adding this formula in cell G36 (the cell with the checkbox)

=IF(F36>=225000, true,)
Original Poster Brandon .Docherty marked this as an answer
Helpful?
All Replies
Recommended Answer
Nov 25, 2020
Hi Brandon,

For this single cell this could be a simple as adding this formula in cell G36 (the cell with the checkbox)

=IF(F36>=225000, true,)
Original Poster Brandon .Docherty marked this as an answer
false
14789986705103638530
true
Search Help Center
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false
false