How to make a broader outline based on an "if" statement

D

dave wagner

What I want to do is, if cell B1 (is not blank) then cell E1 will have a
border outline (I trying to create a checkbox for checking off when the task
iscompleted).

Any suggestions on how to do this?

Thanks in advance.
 
A

Alan

Try Conditional Formatting, use this formula and set the format to your
needs,
=B1<>0

Regards,
Alan.
 
Top