check or uncheck a check box based on a cell value
1. Please, do not use all capitals, it's as if you are shouting!
2. If the cell with the $ amount is A1 then enter =A1<0 in B1 (or any other
empty cell) and give B1 as linked cell of the checkbox!
--
Regards!
Stefi
€žRTKCPA€ť ezt Ă*rta:
IN EXCEL, I WANT TO HAVE A CHECK BOX CHECKED IF A DOLLAR AMOUNT IS ENTERED IN
A CELL AND UNCHECKED IF THE CELL IS ZERO
|