Conditional Formatting

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I can't seem to get this right. My formula can return a
number, text, or two things together with the &, I think
that still counts as text, or it can return the "" value.
I would like to put a border around the cell only when
its value is not "". I tried a few different things, but
they only work when the value is a number. Any ideas for
text values?
 
Scott

Use something like: Formula is =LEN(TRIM(D4))<>0 and format your
border

Regards

Trevor
 
Hi
a formula can't alter formats. So no chance to do this.
You may have a look at conditional formating:
- select your cell (lets say it's A1)
- goto 'Format - Conditional Format'
- Enter the formula
=A1<>""
- choose a format
 
Back
Top