R RTKCPA Feb 3, 2010 #1 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
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 Feb 3, 2010 #2 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:
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:
