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

[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.

 

[Alan]

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

Regards,
Alan.

 

[Max]

One way which might suffice via normal Cond Formatting?

Select E1
Format > Conditional Formatting
Formula is: =B1<>""
Click Format button > Border tab
Select desired line style & color* > Outline > OK
Click OK at the main dialog

*Border format options are limited in CF

And, depending on how 'blank' is defined, alternative conditional format
formulae which could be used (from a recent post by Harlan):
=NOT(ISBLANK(B1))
or equivalently
=COUNTA(B1)

 

[dave wagner]

Thanks, it is just what I needed.

 

[Max]

You're welcome, Dave !