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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to creat a check box 1
Forms Check Box cell link 4
Is there a formula to change number to word. Ex. $10 > ten dollar 2
Check box question??? 4
when a "check box" is checked, a "result" to be shown in another c 2
check box 1
check and uncheck macro 3
CHECK BOX - Can I use it as a sales tax yes or no calculation ? 1

Top