check or uncheck a check box based on a cell value

R

RTKCPA

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
 
S

Stefi

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:
 
Top